导航

11 2015 档案

[SQL]查询表里的字段名

摘要：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 beeone 阅读(683) 评论(0) 推荐(0)

[SQL]查询数据库里都有哪些自己建的表

摘要：方法一：SELECT *FROM FTCE_ACCS.INFORMATION_SCHEMA.TABLES Where TABLE_TYPE='BASE TABLE'--------------------------------------------------------------... 阅读全文

posted @ 2015-11-24 11:31 beeone 阅读(793) 评论(0) 推荐(0)