on C.[object_id]=FK.fkeyid
ON C.[object_id]=G.major_id and c.column_id=g.minor_id

isIdentity=CASE WHEN C.is_identity=1 THEN N'√'ELSE N'' END,

SELECT name FROM sysindexes WHERE indid in( SELECT indid FROM sysindexkeys WHERE id = c.[object_id] AND colid=c.column_id))) then '√' else '' end,

TabForeignName=ISNULL(IDX.FKName,N''),

[uniqueidentifier],[money],[ntext],[real],[smalldatetime],[smallint],[smallmoney],
ON C.[object_id]=D.parent_object_id
WHERE C.column_id=1
columnName=C.name,
left JOIN sys.extended_properties G
TableDesc= O.type
ns=ss.name
FKName=o.name,
ORDER BY TableName
ON C.[object_id]=IDX.fkeyid
AND C.[object_id]=PTB.major_id
LEFT JOIN sys.extended_properties PTB
ON IDX.rkeyid=O.[object_id]
FROM sys.columns C
O.object_id AS TableId,
ON C.user_type_id=T.user_type_id
AND O.type='U'

复制代码 代码如下:

fState=ISNULL(G.value,N''),
select
SELECT
INNER JOIN sys.objects O

1.查询当前数据库所有表

on IDX.rkeyid=ss.id
TableName=O.name ,
typeNum=T.name,
typeLength=C.max_length,

3.字段

2.查询当前表所有字段，数据，约束

AND O.type='U'
defaultData=ISNULL(D.definition,N''),
FROM sys.columns C
ORDER BY O.name,C.column_id

要加单引号varchar,char,nvarchar,nchar,text,ntext,datetime
isForeign=case when exists(select * from sysforeignkeys fk where C.[object_id]=FK.fkeyid AND C.column_id=FK.fkey)then '√' else '' end,
IDX.fkeyid,
不需要加int,numeric,bit 不需要加

(
isAbleNull=CASE WHEN C.is_nullable=1 THEN N'√'ELSE N'' END,
FROM sysforeignkeys IDX
LEFT JOIN sys.default_constraints D
and IDX.RKEY=SS.COLID
columnLine=C.column_id,
AND O.type='U'
tabName=O.NAME,
ON PTB.class=1
LEFT JOIN -- 索引及主键信息
and C.column_id=FK.fkey
[sql_variant],[text]

left join syscolumns ss
AND C.column_id=D.parent_column_id
SELECT
INNER JOIN sys.objects O
AND O.is_ms_shipped=0

AND C.default_object_id=D.[object_id]
AND PTB.minor_id=0
OutNameCol=ISNULL(IDX.ns,N'')
isPrimary=case when exists(SELECT 1 FROM sysobjects where xtype='PK' and parent_obj=c.[object_id] and name in (
ON C.[object_id]=O.[object_id]

带长度：[binary],[char],[decimal],[nchar],[numeric],[nvarchar],[varbinary][varchar]
left join sysforeignkeys fk
ON C.[object_id]=O.[object_id]
AND C.column_id=IDX.fkey

INNER JOIN sys.types T
AND O.is_ms_shipped=0
)IDX
ON C.user_type_id=T.user_type_id

WHERE O.name=N'{0}' ------要查询的表名
INNER JOIN sys.types T
IDX.fkey,
不用带：[bigint],[bit],[datetime],[float],[image],[int],[xml],[timestamp],[tinyint],

复制代码 代码如下:

INNER JOIN sys.objects O
AND O.is_ms_shipped=0