获取数据字典 存储过程

 

-- =============================================
-- Author:-- Create date:-- Description: <获取数据字典>
-- =============================================
ALTER procedure [dbo].[Sp_TableColumn]
@TableName nvarchar(100)
as 
SELECT    
表名=case   when   a.colorder=1   then   d.name   else   ''   end,
字段序号=a.colorder,    
字段名=a.name,      
标识=case   when   COLUMNPROPERTY(   a.id,a.name,'IsIdentity')=1   then   'True'   else   'False'   end,      
主键=case   when   exists(SELECT   1   FRO