Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. ATL / WTL / STL
  4. Query to copy the table with Data and Constraints in SQL Server

Query to copy the table with Data and Constraints in SQL Server

Scheduled Pinned Locked Moved ATL / WTL / STL
databasesql-serversysadmintutorial
4 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    siddisagar
    wrote on last edited by
    #1

    How to copy table with Data and constraints from one database to another database Database A have 300000 columns I need above table to copy in Database B but with constraints I am using below Query but here constraints are misssing SELECT * INTO Table1 FROM A.dbo.Table1 Pls suggest me correct Query

    L 1 Reply Last reply
    0
    • S siddisagar

      How to copy table with Data and constraints from one database to another database Database A have 300000 columns I need above table to copy in Database B but with constraints I am using below Query but here constraints are misssing SELECT * INTO Table1 FROM A.dbo.Table1 Pls suggest me correct Query

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #2

      Wrong forum.

      L u n a t i c F r i n g e

      S 1 Reply Last reply
      0
      • L Lost User

        Wrong forum.

        L u n a t i c F r i n g e

        S Offline
        S Offline
        siddisagar
        wrote on last edited by
        #3

        I could not see SQL Server Option so I Posted here. Please Take it forward

        L 1 Reply Last reply
        0
        • S siddisagar

          I could not see SQL Server Option so I Posted here. Please Take it forward

          L Offline
          L Offline
          Lost User
          wrote on last edited by
          #4

          Try the General Database forum instead - you'll have a better chance of getting help there.

          L u n a t i c F r i n g e

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups