sql server 2005:1 --SQL SERVER 2005 生成代码需要知道的SQL语句2 use LibrarySystem3 --查询当前数据库所有表和其的主键字段,字段类型,长度,是否为空值4 SELECT d.name as TableName,a.nam ...
sql server 2005:
1 --SQL SERVER 2005 生成代码需要知道的SQL语句2 use LibrarySystem3 --查询当前数据库所有表和其的主键字段,字段类型,长度,是否为空值4 SELECT d.name as 'TableName',a.name as 'FieldName',b.name as 'TypeName',a.length as 'Length',a.isnullable as 'IS_NULL' FROM syscolumns a, systypes b,sysobjects d ,INFORMATION_SCHEMA.KEY_COLUMN_USAGE c WHERE a.xtype=b.xusertype and a.id=d.id and d.xtype='U' and c.TABLE_NAME = d.name and c.COLUMN_NAME=a.name5 --获取BookKindList表结构里面的字段名, 类型,长度6 SELECT c.name as FieldName,t.name as FieldType, c.length as FieldLength FROM SYSCOLUMNS c inner join systypes t on c.xusertype=t.xusertype WHERE c.ID = OBJECT_ID('BookKindList')7 --
原标题:sql: 表结构查询
关键词:sql
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。