How create table structure only from tableA to TableB if
TableA have some data?
- 4 Answers
- 5679 Views
- I also Faced
- E-Mail Answers
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
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What specific conditions database should meet, before you can bulk copy data into it using bcp?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What is the query and subquery?
How to execute a stored procedure in ms sql server?
What is a performance monitor?
What do you mean by data integrity?
What is subquery in sql?
What do you understand by SQL*Net?
What is command parameter in ssrs?
How to select all columns of all rows from a table with a select statement in ms sql server?
Define the one-to-one relationship while designing tables.
When would you use it?
What is attribute? : sql server analysis services, ssas
Why use view instead of a table?
