How create table structure only from tableA to TableB if
TableA have some data?
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 are the properties of the relational tables?
When cursors are useful?
What is an example of a primary key?
Explain what are page splits? : SQL Server Architecture
How to enforce security in sql server? : sql server security
What is a domain constraint give an example?
Can we update data in a view?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
How to make a remote connection in a database?
What are the commands used in DCL?
What are system databases into sql server (2005/2008) : sql server database administration
What are different types of replication in sql server?
How to retrieve error messages using odbc_errormsg()?
How to delete exactly duplicate records from a table?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?