樹

摘要： 1.查询当前数据库所有表SELECT O.object_id AS TableId, TableName=O.name , TableDesc= O.type FROM sys.columns C INNER JOIN sys.objects O ON C.[object_id]=O.[object_id] AND O.type='U' AND O.is_ms_shipped=0 INNER JOIN sys.types T ON C.user_type_id=T.user_type_id... 阅读全文