what command is used to create a table by copying the
structure of another table?
Answer Posted / pradip jain
SELECT * INTO tblNew FROM tblOld WHERE 1=2
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of sql stored procedure?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
How do I get to sql server configuration manager?
What is database architecture? : SQL Server Architecture
What is save transaction and save point?
How to restore performance issues and how to check?
What does man by sql wildcard characters in sql server?
How to connect to SQL Azure Database by using sqlcmd?
How to retrieve error messages using odbc_errormsg()?
Where the sql logs gets stored? : sql server database administration
How many primary keys are possible in a table?
How to define output parameters in stored procedures?
How many types of stored procedures are there in sql server?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is importing utility?