what command is used to create a table by copying the
structure of another table?
Answer Posted / hokar
SELECT * INTO tabname1 FROM tabname2 WHERE 1=2 (TO copy
only the structure)
| Is This Answer Correct ? | 18 Yes | 4 No |
Post New Answer View All Answers
What is the index requirement in SQL Azure?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Does a server store data?
What are the rendering extensions of ssrs?
What is the maximum length of an alert name?
How to create a dml trigger using create trigger statements?
Where cross join is used?
What are the acid properties?
Can foreign key be deleted?
What is a non clustered primary key?
What are .mdf files?
what is a join? : Sql server database administration
Why use sub query in sql server and list out types of sub queries?
Write SQL queries on Self Join and Inner Join.
How many types of attribute relationships are there? : sql server analysis services, ssas