Interested to Buy Any Domain ? << Click Here >> for more details...
How create table structure only from tableA to TableB if
TableA have some data?
- 4 Answers
- 6892 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is cross join in sql server joins?
Explain the working of sql privileges?
What command would you use to create an index?
What is a primary key?
What is difference between rollback immediate and with no_wait during alter database?
Can two different columns be merged into single column? Show practically?
What samples and sample databases are provided by microsoft?
Explain transaction server auto commit?
What is bit data type?
How to view the error log for any specific instance? : sql server database administration
What is normalization and what are the advantages of it?
What is rtm version in sql server?
Define Business Edition in SQL Azure?
What is the stored procedure?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
