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
How are the exceptions handled in sql server programming?
How to concatenate two binary strings together?
How to find out what is the default collation in a database?
What is blocking and how would you troubleshoot it? : sql server database administration
What is #table in sql server?
Tell me what is the significance of null value and why should we avoid permitting null values?
Explain a join?
What is the library index called?
What is the difference between system objects and user objects?
Explain syntax for viewing, dropping and disabling triggers?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
Can you please explain the difference between function and stored procedure?
What is ms sql server service broker?
What is the difference between a view and a stored procedure?
what are the Prerequisites for Replication?