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 are the purposes and advantages stored procedure?

885

What are scalar functions?

946

What is a file group?

1014

Define inner join? Explain with an example?

920

What are the new security features added in sql server 2012? : sql server security

947

what are acid properties? : Sql server database administration

926

What is default constraint?

931

What are types of scd? : sql server analysis services, ssas

971

Name few of the dcl commands in sql?

951

What are horizontal and vertical scaling?

170

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

910

Is INSTEAD OF trigger directly applicable to Table ?

957

What is the use of RDBMS?

956

Can a synonym name of a table be used instead of a table name in a select statement?

972

Tell me what is the order in which the sql query is executed?

894