How create table structure only from tableA to TableB if
TableA have some data?
- 4 Answers
- 6332 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 the process of normalization?
Can a database be shrunk to 0 bytes, if not, why?
What is the full meaning of dml?
What are commit and rollback in sql?
What are the advantages of using third-party tools?
What is difference between group by and having?
How do I create a stored procedure in dbml?
What is indexing a document?
what information is maintained within the msdb database? : Sql server administration
What is explicit cursors?
What do you mean by collation recursive stored procedure?
Define left outer join in sql server joins?
What is query processing?
how many layers of tcp/ip protocol combined of? : Sql server database administration
Can we perform backup restore operation on tempdb?
