新增數(shù)據(jù)用戶，角色為public，映射到待獲取表結(jié)構(gòu)的數(shù)據(jù)庫上，授與用戶在該數(shù)據(jù)庫上的身份為db_owner

執(zhí)行如下SQL語句：

select   
syscolumns.name as [Name] ,  
systypes.name as [Type],  
syscolumns.length AS [Size],  
syscolumns.xprec As [Precision],   
ISNULL(syscolumns.scale, 0) AS [Scale],  
sys.extended_properties.value as [Mark],  
syscolumns.isnullable as [NULL],  
(Case when exists(  
select 1 from sysobjects  
 inner join sysindexes on sysindexes.name = sysobjects.name    
 inner join sysindexkeys on sysindexes.id = sysindexkeys.id and  sysindexes.indid = sysindexkeys.indid   
 where xtype='PK' and parent_obj = syscolumns.id      
 and sysindexkeys.colid = syscolumns.colid) then 1 else 0 end) AS [PK],  
(Case syscolumns.status when 128 then 1 else 0 end) AS [Identity]  
 from syscolumns    
 inner join systypes on (    
syscolumns.xtype = systypes.xtype    
 and systypes.name <>'_default_'     
 and systypes.name<>'sysname')    
 left outer join sys.extended_properties on (    
sys.extended_properties.major_id=syscolumns.id     
 and minor_id=syscolumns.colid)    
 where syscolumns.id = (select id from sysobjects where name='NDS_TFileForm')   
 order by syscolumns.colid  

標簽： 數(shù)據(jù)庫

版權(quán)申明：本站文章部分自網(wǎng)絡，如有侵權(quán)，請聯(lián)系：west999com@outlook.com
特別注意：本站所有轉(zhuǎn)載文章言論不代表本站觀點！
本站所提供的圖片等素材，版權(quán)歸原作者所有，如需使用，請與原作者聯(lián)系。