sql server create table as select into的相關公司資訊
scripting - In SQL Server, how do I generate a CREATE TABLE statement for a given table? - Stack Ove

scripting - In SQL Server, how do I generate a CREATE TABLE statement for a given table? - Stack Ove

瀏覽:1358
日期:2025-04-24
I've modified the version above to run for all tables and support new SQL 2005 data types. It also retains the primary key names. Works only on SQL 2005 (using cross apply). select 'create table [' + so.name + '] (' + o.list + ')' + CASE WHEN tc.Constrain...看更多