what command is used to create a table by copying the
structure of another table?
- 7 Answers
- 13672 Views
- I also Faced
- E-Mail Answers
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
Explain few examples of RDBMS?
What are the different SQL Server Versions you have worked on?
Explain about merge replications?
When we should use @@error?
What is the difference between nvl and nvl2?
What samples and sample databases are provided by microsoft?
Do you know how to send email from database?
What are page splits? : SQL Server Architecture
Do you know what is openxml in sql server?
What is dynamic cursor in SQL SERVER?
Describe in brief authentication modes in sql server.
What protocol does sql server use?
Why do we use trigger?
Define cursor locking
Explain primary key in sql server?
