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


Please Help Members By Posting Answers For Below Questions

What is the difference between delete and truncate statements?

567


on line cluster can we make if yes tell me the procedure

1514


Mention the uses of stored procedures.

571


What are the differences between union, intersect, and minus operators?

574


Is natural join and equi join same?

525






What is normalization and what are the advantages of it?

517


List the advantages of using stored procedures?

560


How do I start sql server agent automatically?

502


What is the new security features added in sql server 2016? : sql server security

613


What's new in sql management studio for sql server? : sql server management studio

578


How you can get the list of largest tables in a database?

525


Name three of the features managed by the surface area configuration tool? : sql server security

509


Do you know how to store and query spatial data?

604


How to provide login information for a new odbc dsn?

538


Define candidate key, alternate key, and composite key.

532