what command is used to create a table by copying the
structure of another table?
- 7 Answers
- 13670 Views
- I also Faced
- E-Mail Answers
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
What is the most common type of join?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
Difference between group by clause and having clause in SQL?
Distinguish between nested subquery and correlated subquery?
What is data source in connection string?
What are the different types of replication are there in sql server 2000?
How to assign null values to variables or columns?
How to specify the collation for a character data type in ms sql server?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What is an etl file?
What is index in an assignment?
What is an indice?
Why use “nolock” in sql server?
Why use stored procedures in sql server?
what is package and it uses and how can u call a package
