what command is used to create a table by copying the
structure of another table?
Answer Posted / hokar
SELECT * INTO tabname1 FROM tabname2 WHERE 1=2 (TO copy
only the structure)
Is This Answer Correct ? | 18 Yes | 4 No |
Post New Answer View All Answers
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
What is the advantage of sql server?
Explain use of expression builder.
Define magic tables in sql server?
What is the use of keyword with encryption.
What is best institute to Learn DotNET And SQL in chennai?
Determine when an index is appropriate?
How to create a user name in a database?
Can you please differentiate between a primary key and a unique key?
What is bcnf normalization form?
Why we should not use triggers?
What are different types of constraints?
What is it unwise to create wide clustered index keys?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What is store procedure? When do you use?