select * into oldtable from newtable where oldtable =newtable

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

Question Posted / naik

Answer Posted / naik

select * into oldtable from newtable where oldtable
=newtable

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What do you mean by collation recursive stored procedure?

1110

What is the use of for clause?

1166

How to list all field names in the result set using mssql_field_name()?

952

what is the system function to get the current user's user id? : Sql server database administration

1073

What is cursors? And what are the different types of cursor?

1195

What is model database in sql server?

1103

What is command parameter in ssrs?

166

Explain the disadvantages of cursors?

1209

Can we use custom code in ssrs?

1169

Should you normalize audio?

1007

What is SQL Azure Fabric?

112

How to use order by with union operators in ms sql server?

1067

How to set a database state to offline in ms sql server?

1107

What are different types of schemas?

990

Explain the commands in sql server?

1098