用SQL Script取得Table Structure
早前被要求要取出SQL Table的Structure而去找了一下如何用Script去完成
select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='TABLE_NAME'
select * from INFORMATION_SCHEMA.COLUMNS where TABLE_CATALOG='DB_NAME' AND TABLE_SCHEMA='dbo'
2020-01-24