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

Answer Posted / jaydev

SELECT TOP 0* INTO tabname2 FROM tabname1

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can group functions be used in the order by clause in ms sql server?

588


role of sql sever 2005 in database rather than any other database

1510


What are a scheduled jobs or what is a scheduled tasks?

494


How to create user defined functions with parameters?

642


What are constraints in microsoft sql server?

561






What are sparse columns?

584


Describe different Processing Modes offered by SSRS?

164


What are sql servers used for?

509


What are different types of statement?

525


What are the advantages of using third-party tools?

551


What are the different types of cursor?

603


What is the maximum size of a dimension? : sql server analysis services, ssas

560


Can sql servers link to other servers like oracle?

468


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

524


What is a performance monitor?

554