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

Sql technical questions

1266

Can a view be mutating? If yes, then how?

1018

Which is better cte or subquery?

1025

Define union, minus, union all, intersect ?

996

How is indexing done in search engines?

980

What is transaction control language (tcl)?

1129

How do you truncate?

902

How do I create a memory optimized filegroup?

956

How do I run a program in pl sql?

994

What is information schema in sql?

1066

What are all the different normalization?

1036

How exception is different from error?

1009

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2475

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1033

How many tables can you join in sql?

952