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
How to delete duplicate records based on single column from a table?
What is cursors? And what are the different types of cursor?
Does sql server 2000 clustering support load balancing?
Does sql server use java?
What is cube dimension? : sql server analysis services, ssas
What are different types of statement?
What are the 7 disadvantages to a manual system?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
How will you find out if there are expensive SQL statements running or not?
Why olap is used?
What are the five major components of a dbms?
How can you hide the sql server instances?
What is 2nf normalization?
How to change a login name in ms sql server?
can a database be shrunk with users active? : Sql server administration