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 a unique constraint?

598

What is varchar example?

557

Which tcp/ip port does sql server run?

518

What does pl sql developer do?

498

What does dml mean?

536

What is normalization in sql?

515

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

489

How do I add a database to sql?

558

What is pl/sql table? Why is it used?

550

How to use distinct and count in sql query? Explain

597

Can we use having without group by in sql?

535

What is oracle pl sql developer?

518

What is sql analyzer?

523

Explain what is a column in a table?

557

What is rowid in sql?

496