Select * into newnew1 from newnew WHere 1=2

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

Question Posted / kumar.t

Answer Posted / kumar.t

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the 7 disadvantages to a manual system?

906

What are the characteristics of modern DBMS?

1029

How to send email from database?

947

How do I start and stop sql server?

965

Can foreign key be deleted?

870

your distribution database is full what will u do

2124

How can change procedure in sql server?

983

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

982

Tell me extended events in sql server 2008?

948

Which language rdl files made of?

124

What are “lock” hints?

998

What are key constraints?

918

What is the difference between web edition and business edition?

111

What are the differences between DDL, DML and DCL in SQL?

1169

Explain syntax for disabling triggers?

968