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 do you mean by dbms? What are its different types?
What are stuff and replace function?
how to use 'mysql' to run sql statements? : Sql dba
what are rollup and cube in t-sql? : Transact sql
What are the differences between in and exists clause?
What are the types of triggers in sql?
What does cursor do in sql?
What is the difference between left join and right join?
What does truncate mean in sql?
What is normalization sql?
What are predefined functions in sql?
What are the different dml commands in sql?
Can we use ddl statements in stored procedure sql server?
What are the limitations of sql express?
What is acid property in a database?