How create table structure only from tableA to TableB if
TableA have some data?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / karthik
Create table emp1
as
select * from emp
where 1=2
It will give the structure of the table.
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / mits
Create table newtablename
from oldtablename
where 1=2
Is This Answer Correct ? | 4 Yes | 6 No |
what is the basic diffrence betn a col declared in char(1) and in varchar(1)
What is the difference between NOROW and LOCKROW?
0 Answers Accenture, Honeywell, Satyam,
Write a query for primary key constraint with identity key word?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
What does the not null constraint do?
What is the difference between a clustered index and a non-clustered index?
How to create and drop temp table in sql server?
What is Left Outer Join?
What is the use of Port no?
What is the datatype of rowid?
What is normalization and its types?
What happens if we shrink log file in sql server?