SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'Address'
但是有什么办法(对于未知数量的列),我可以得到每列的名称和数据类型和长度？
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'Address'
MSDN Docs on INFORMATION_SCHEMA.COLUMNS
INFORMATION_SCHEMA.COLUMNS
