摘要：Select Name from syscolumns Where ID=OBJECT_ID('表名')select * from information_schema.tables WHERE TABLE_TYPE='BASE TABLE' OR TABLE_TYPE='VIEW'select *...
阅读全文
posted @ 2015-11-24 14:03
11 2015 档案
摘要：方法一：SELECT *FROM FTCE_ACCS.INFORMATION_SCHEMA.TABLES Where TABLE_TYPE='BASE TABLE'--------------------------------------------------------------...
阅读全文
posted @ 2015-11-24 11:31
