Tuesday, October 19, 2010

You want to Copy Only Schema of one table into another new table. How will you do that ?

Ans :

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

No comments:

Post a Comment

How to check local and global angular versions

 Use the command ng version (or ng v ) to find the version of Angular CLI in the current folder. Run it outside of the Angular project, to f...