| |
GeekInterview.com > Interview Questions > Database > SQL Server
| Print | |
Question: How will you copy the structure of a table without copying the data?
|
| March 03, 2007 07:05:07 |
#7 |
| Deependra Singh Bhandari |
Member Since: Visitor Total Comments: N/A |
RE: How will you copy the structure of a table without...
|
| create table NEWTable AS select * from OLDTABLE where 1=2can u used this command in Sql-Server -2005, i have used id but it is not workingwe can used this method as followingselect column name,columnname into newtablename from oldtablename where 1=2 |
| |
Back To Question | |
