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

Answer Posted / jaydev

SELECT TOP 0* INTO tabname2 FROM tabname1

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is pessimistic concurrency?

709


How to filter out duplications in the returning rows in ms sql server?

812


How do you test your database? : sql server database administration

716


What is the purpose of a table?

731


What is the difference between index seek vs. Index scan?

771






How to find the list of fixed hard drive and free space on server?

782


Explain go command in sql server?

724


Can two tables share the same primary key?

682


How to modify existing triggers using "alter trigger"?

702


What do you understand by coalesce in sql server?

726


What is the default port for SQL Server over a firewall?

783


Why olap is used?

724


What is intellisense?

787


What is query processing?

692


How many types of schemas are there?

732