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

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1086

Is the primary key an index?

1026

What is cursor and why it is required?

1183

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

958

What are analytical functions in sql?

1033

What are pl/sql cursors?

1055

What is difference between my sql and sql?

1077

Is sql sequential or random?

1039

What is crud sql?

990

Can we join 3 tables in sql?

1046

What is substitution variable?

1056

What are the 3 modes of parameter?

1156

what is 'trigger' in sql? : Sql dba

1089

What is foreign key in sql with example?

939

How many sql statements are used? Define them.

1043