How create table structure only from tableA to TableB if
TableA have some data?
Answer Posted / sunny
to copy only the structure
select * into table2 from table1 where 1=2
to copy the table along with the records
select * into table2 from table1 where 1=1
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
Explain concepts of analysis services?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What is resource governor in sql server?
What different steps will a sql server developer take to secure sql server?
can any body tell me how to know the password of current user in sql server
what are the core components of SSRS?
What is the difference between value type and reference type?
What is the purpose of sql profiler in sql server?
What happens if null values are involved in boolean operations?
What will happen if a column containing char type data is changed to the nchar data type?
List out what other servers you can use with ssrs?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
What is entity data services?
What is merge replication?
If a stored procedure is taking a table data type, how it looks?