mysql所有的表结构_MYSQL库内所有表名及表结构获取

MSSQL表名：

SELECT

— 当前自增进字段最大值

–ident_current(‘TableName’),

TableName= D.name ,Impdate=GETDATE() ,lasetDate=null,isrun=0,maxkey=0

FROM sysobjects D

WHERE D.xtype=’U’ and D.name<>’dtproperties’

更新自增进字段 JAVA

MSSQL表结构：

SELECT

— 当前自增进字段最大值

ident_current(‘TableName’),

TableName= Case When A.colorder=1 Then D.name Else ” End,

TableDesc= Case When A.colorder=1 Then isnull(F.value,”) Else ” End,

FieldNum= A.colorder,

FieldName= A.name,

FieldDesc = isnull(G.[value],”),

IsAdd= Case When COLUMNPROPERTY( A.id,A.name,’IsIdentity’)=1 Then ‘√’Else ” End,

FieldType= B.name,

FieldBytes= A.Length,

FieldLength= COLUMNPROPERTY(A.id,A.name,’PRECISION’),

PointDigit= isnull(COLUMNPROPERTY(A.id,A.name,’Scale’),0),

IsNul = Case When A.isnullable=1 Then ‘√’Else ” End,

SetValue = isnull(E.Text,”)

FROM syscolumns A

Left Join systypes B On A.xusertype=B.xusertype

Inner Join sysobjects D On A.id=D.id and D.xtype=’U’ and D.name<>’dtproperties’

Left Join syscomments E on A.cdefault=E.id

Left Join sys.extended_properties G on A.id=G.major_id and A.colid=G.minor_id

Left Join sys.extended_properties F On D.id=F.major_id and F.minor_id=0

where d.name=’Country’ –若是只查询指定表,加上此条件

Order By

A.id,A.colorder

原文链接：https://www.cnblogs.com/peter-lau/p/12424795.html

本站声明:网站内容来源于网络,若有侵权,请联系我们,我们将及时处理。