Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • SQL SERVER: Copy structure of an existing table without data into new table

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 865
    Comment on it

    SQL SERVER: Copy structure of an existing table without data into new table

     

    Create a table named "tblStudents" in database and insert some dummy data into it.

     

    CREATE TABLE tblStudents
    (
        StudentId INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
        StudentName VARCHAR(100),
        Gender VARCHAR(100),
        Course VARCHAR(100)
    )

     

    Query to insert data into "tblStudents"

     

    Insert Into tblStudents values 
    ('Deepika','Female','MCA'),
    ('Jyoti','Female','MCA')

     

    Table "tblStudents" data can be seen by firing following query :-

     

    Select * from tblStudents

     

    Output of above query :-

     

     

    There are two ways of copying structure of an existing table without data into new table

     

    1.  The following is the first query to be executed

     

    SELECT * INTO tblNewStudents FROM tblStudents WHERE 1=0

     

         2. The following is the second query which can be executed

     

    SELECT TOP 0 * INTO tblNewStudents FROM tblStudents

     

    Both the above queries will create a new table "tblNewStudents" having same structure as table "tblStudents". The columns of table "tblStudents" along with datatype are copied but these quries will not copy data, indexes, keys, constraints etc of the source table to target table.

     

    The following query is fired to see table  "tblNewStudents"

     

    select * from  tblNewStudents

     

    Output is an empty table :

     

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: