SQL Server dba-daily query view

1. query table name or column name in Chinese comments (SQL Server 2008)

Select T.object_id from sys.tables tjoins on T.  object_id=and='ms_description'  and p.minor_id=0;

1.1 Query Table name Chinese comments

SelectT1.*, T2.name ascolumn_name from (SelectT.object_id, P.major_id,p.minor_id,t.name asTables_name, P.value,t.type,t.type_desc fromsys.tables TJoinsys.extended_properties P onT.object_id =p.major_id andP.name= 'ms_description') T1 Left Joinsyscolumns T2 onT1.object_id=t2.id andt1.minor_id=T2.colid;

1.2 Check out the table name and column name in Chinese

SQL Server dba-daily query view