what command is used to create a table by copying the
structure of another table?
Answer Posted / hokar
SELECT * INTO tabname1 FROM tabname2 WHERE 1=2 (TO copy
only the structure)
Is This Answer Correct ? | 18 Yes | 4 No |
Post New Answer View All Answers
How to drop an existing user defined function in ms sql server?
What is open database communication (odbc)?
Why is normalisation important?
what changed between the previous version of sql server and the current version? : Sql server database administration
What is the importance of three tier architecture?
How do I get to sql server configuration manager?
You want to use a perspective in an mdx query. How do you select the perspective?
How to create user defined functions with parameters?
What is function of master database?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
How to list all triggers in the database with sys.triggers in ms sql server?
Give an example of SQL injection attack ?
How to find the list of fixed hard drive and free space on server?
How to check if stored procedure is running in sql server?
What causes index fragmentation?