SELECT TOP 0 * INTO employee2 FROM dbo.employeedtls using this command we

what command is used to create a table by copying the
structure of another table including constraints ?

Question Posted / anksuh

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

Please Help Members By Posting Answers For Below Questions

How can you create an empty table from an existing table?

1010

Does sql backup shrink transaction log?

914

When is the explicit cursor used ?

977

What does over partition by mean in sql?

920

What is the primary key?

877

Explain what is a database?

1037

Does view contain data?

983

What is java sql connection?

964

Is there any restriction on the use of union in embedded sql?

1100

What are inner and outer joins examples of both?

879

What are character functions in sql?

892

what is a record in a database ? : Sql dba

995

What is a Mapplet?

1057

what are all the common sql function? : Sql dba

1010

Differentiate pl/sql and sql?

1011