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 throw custom exception in Stored Procedure?
What are some examples of schemas?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Is mysql the same as sql server?
What is candidate key with example?
How to set database to be read_only in ms sql server?
What is the difference between an index and a unique index?
Why would you use sql agent?
Can you explain different types of locks in sql server?
What is the difference between inner join and equi join?
In which tcp/ip port does sql server run? Can it be changed?
Which is the main third-party tool used in sql server?
What are the differences between ms sql server & oracle?
Why Master database is required?
What is mean by candidate key?