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

Answer Posted / kumar.t

Select * into newnew1 from newnew WHere 1=2

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sub-query in sql server? Explain its properties.

577


What are 3 ways to get a count of the number of records in a table?

609


Which are the important points to note when multilanguage data is stored in a table?

516


Do you know what are pages and extents? : SQL Server Architecture

550


What are the different types of indexes?

611






What is a covering index?

531


How to select an exiting database using mssql_select_db()?

509


explain different levels of normalization? : Sql server database administration

522


What is tablesample?

571


How you can change a cross join into an inner join?

549


Which autogrowth database setting is good?

615


Write an sql query to find first weekday of the month?

484


How can I create a new template for import ? : sql server management studio

595


What is the contrast between sql and pl/sql?

622


How to receive output values from stored procedures?

483