what command is used to create a table by copying the
structure of another table?
Answer Posted / narsing
SELECT * INTO tabname1 FROM tabname2 WHERE 1<>2 (TO copy
only the structure)
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is the difference between delete and truncate statements?
on line cluster can we make if yes tell me the procedure
Mention the uses of stored procedures.
What are the differences between union, intersect, and minus operators?
Is natural join and equi join same?
What is normalization and what are the advantages of it?
List the advantages of using stored procedures?
How do I start sql server agent automatically?
What is the new security features added in sql server 2016? : sql server security
What's new in sql management studio for sql server? : sql server management studio
How you can get the list of largest tables in a database?
Name three of the features managed by the surface area configuration tool? : sql server security
Do you know how to store and query spatial data?
How to provide login information for a new odbc dsn?
Define candidate key, alternate key, and composite key.