Get information about the field names, field descriptions, data types, primary keys, and other tables of the MSSQLSERVER database table

SQL script:

SELECTTableName= Case    whenA.colorder=1    ThenD.nameElse   "'   End,---table nameTableshowsthat= Case    whenA.colorder=1    Then   IsNull(F.value,"')Else   "'   End,---Table DescriptionTheserialnumberfield=A.colorder,---Field ordinalFieldName=A.name,---field nameIdentification= Case    when   ColumnProperty(A.id,a.name,'isidentity')=1    Then   '√'Else   "'   End, PrimaryKey= Case    when   exists(SELECT   1    fromsysobjectswhereXtype='PK'    andNameinch   (SELECTName fromsysindexesWHEREIndidinch(SELECTIndid fromSysindexkeysWHEREId=a.ID andColid=a.colid ))) Then   '√'   Else   "'   End,---Identify primary key[Type]=B.name,---Data typeTakeupthenumberofbytes=A.length,---Number of bytes occupied[Length]=ColumnProperty(A.id,a.name,'PRECISION'),---LengthDecimaldigits=IsNull(ColumnProperty(A.id,a.name,' Scale'),0),---Number of decimal digitsAllowEmpty= Case    whenA.isnullable=1    Then   '√'Else   "'   End,---Allow null[Default]=IsNull(E.text,"'),---Default ValueFieldsthat=IsNull(g.[value],"')---Field Description fromsyscolumns a Left   JoinSystypes b onA.xusertype=B.xusertypeInner   Joinsysobjects D ona.ID=D.id andD.xtype='U'    andD.name<>'dtproperties' Left   Joinsyscomments E onA.cdefault=e.id Left   JoinSys.extended_properties g ona.ID=g.major_id andA.colid=g.minor_id Left   JoinSys.extended_properties F onD.id=f.major_id andf.minor_id=0 whereD.name='Accounts_user'         --If you query only the specified table, add this conditionOrder    byA.id,a.colorder

Get information about the field names, field descriptions, data types, primary keys, and other tables of the MSSQLSERVER database table