How can I create a table from another table without copying any values from the old table?
- 3 Answers
- 4600 Views
- I also Faced
- E-Mail Answers
Answer Posted / arun
Select top 0
into newtable
from oldtable
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How to change the system date and time from SQL Plus Terminal ?
Where are sql server user names and passwords stored in sql server?
What do you mean by subquery?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
How many types of attribute relationships are there? : sql server analysis services, ssas
Distinguish between commit and rollback?
Explain the xml support sql server extends?
How to loop through returning rows?
What do I need to start working with sql studio? : sql server management studio
In what three ways is the return statement used in a stored procedure?
What does normalization do to data?
What are the different types of backups avaialabe in sql server 2005?
What are locks in sql?
how you can move data or databases between servers and databases in sql server? : Sql server administration
What is dml command?
