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 ereg_replace() and eregi_replace()? : Sql dba

1221

What is a trigger in sql?

1232

How does one load ebcdic data? : aql loader

1253

Can sql function call stored procedure?

1070

Which join is like an inner join?

1091

How do I count duplicates in sql?

1175

How can you save or place your msg in a table?

1035

Can I call a procedure inside a function?

1074

what is meant by urlencode and urldocode? : Sql dba

1234

What is break?

1254

What is dml statement?

999

What is hibernate and its relation to sql?

1166

What is having clause in sql?

1018

What does select count (*) mean in sql?

1073

What is a database trigger?

1128