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

rls

To enable row-level security (RLS) in MS SQL Server (2016 and later) , you need to define a security policy that uses a user-defined, inli...