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
