摘要:
[代码] 阅读全文
摘要:
实际开发中经常为数据字段备注而烦恼,为此写了如下存储过程,一方便查看数据库备注信息. 1 2 create proc [dbo].[GenerateDataDictionaryByTableName] 3 @tableName nvarchar(255) 4 as 5 begin 6 --获取数据表名 7 declare @tableid int 8 declare mycursor Cursor 9 for select object_id from sys.objects where type='U' and name'dtproperties' and n 阅读全文