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
Why truncate is ddl?
What is the cartesian product of table?
What is dirty page?
What is #temp and @table variable in SQL server?
Do you know the policy based administration feature of sql server 2008?
What do you understand by user-defined function in the sql server?
What is index fragmentation in ms sql server?
what is the primary use of the model database? : Sql server administration
What is usually the first word in a sql query?
How to link tables in sql server?
To which devices can a backup be created and where should these devices be located? : sql server management studio
How would you choose between a clustered and a non-clustered index?
What is @@rowcount in sql?
Explain the different types of joins?
What are different backups available in sql server?