How can I create a table from another table without copying any values from the old table?
Answer Posted / arun
Select top 0
into newtable
from oldtable
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are the instances when triggers are appropriate?
What is difference between unique and primary key?
What is the meaning of resultset type_scroll_insensitive?
How to find tables without indexes?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What is self contained multi valued query?
How do I find the default sql server instance?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
is there a column to which a default can't be bound? : Sql server database administration
How to list all objects in a given schema?
How to drop an existing user defined function in ms sql server?
Why we use functions in sql server?
How to backup SQL Server Reporting Services ?
what is package and it uses and how can u call a package
Write a sql query to display the current date?