select *into newtable from oldtable.

CREATE a table from another table

Question Posted / narendra

Answer Posted / narendra

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1963

Does a specific recovery model need to be used for a replicated database? : sql server replication

961

What is the syntax for encrypting a column in SQL Server?

1119

What is sql server database?

1006

Does view occupy space?

941

How do you open a cluster administrator?

1049

How to convert numeric values to integers in ms sql server?

1089

How can we delete Duplicate row in table?

1058

What do you understand by intent locks?

1008

What are the fixed server level roles? : sql server security

1125

Can a table have 2 primary keys?

981

What is Federation Root Database?

104

What is used to replicate sessions between instances in coldfusion clusters?

1071

How to write character string constants or literals in ms sql server?

1019

What programming language would you use to create embedded functions in ssrs?

184