Tuesday, October 19, 2010
You want to Copy Only Schema of one table into another new table. How will you do that ?
select * into new_tablename from original_tableName where 1=2
Just for reference:
To make a copy of a table : "select * into"
select * into new_tablename from original_tableName -- this will copy full table with data
ASP.NET Interview Questions
Share to Twitter
Share to Facebook
Share to Pinterest
Post a Comment
Post Comments (Atom)