SQL Server schema 用法
摘要：
查看所有表名：select name from sysobjects where type='U'查询表的所有字段名：Select name from syscolumns Where ID=OBJECT_ID('表名')根据字段，查字段所在的表，注意要大写select * from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME = 'smpl_id'select * from INFORMATION_SCHEMA.TABLESselect * from INFORMATION_SCHEMA.VIEWS 阅读全文
posted @ 2013-01-24 17:08 alex_lo 阅读(754) 评论(0) 推荐(0) 编辑