來源請參考：
Get Table Schema from MS SQL
SELECT table_schema ,
table_name ,
ordinal_position,
column_name ,
data_type ,
is_nullable ,
character_maximum_length
FROM information_schema.columns
WHERE table_name NOT LIKE 'dnt_%'
AND table_catalog = 'master'
ORDER BY table_name,
ordinal_position
0 意見:
張貼留言