select * into oldtable from newtable where oldtable =newtable

what command is used to create a table by copying the
structure of another table?

Question Posted / naik

Answer Posted / naik

select * into oldtable from newtable where oldtable
=newtable

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are functions in the sql server?

1187

What are the difference between primary keys and foreign keys?

952

How do I view a procedure in sql server?

976

What are the system database in sql server 2008?

1014

What are the five characteristics of good data?

897

Does a full backup include transaction log?

948

What is isnull() operator?

1017

role of sql sever 2005 in database rather than any other database

1920

What are information schema views?

958

Why the trigger fires multiple times in single login?

1189

How to store and query spatial data?

975

Explain the rules for designing files and file groups in sql server?

966

What is an entity-relationship diagram (erd)?

1182

What is application role in sql server database security? : sql server security

1037

Explain ranking functions?

1028