what command is used to create a table by copying the
structure of another table including constraints ?
Answer Posted / anksuh
SELECT TOP 0 * INTO employee2 FROM dbo.employeedtls
using this command we can copying the structure of one table
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between drop and truncate commands?
what is the use of double ampersand (&&) in sql queries?
Write an sql query to select all records from the table?
How can a pl sql block be executed?
What is sql trigger example?
What are the syntax and use of the coalesce function?
Do stored procedures prevent sql injection?
Does group by remove duplicates?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
What programs use sql?
What are the ddl commands?
Write a unique difference between a function and a stored procedure.
Why function is used in sql?
What are the disadvantages of file system?
What is #table in sql?