本文向大家介绍了使用SQL语句提取数据库所有表的表名、字段名的实例代码,在SQLserver 中进行了测试,具体内容如下:
--查询所有用户表所有字段的特征
SELECT D.Name as TableName, A.colorder AS ColOrder, A.name AS Name,
COLUMNPROPERTY(A.ID,A.Name, 'IsIdentity') AS IsIdentity,
CASE WHEN EXISTS
(SELECT 1
FROM dbo.sysob
代码如下:declare str varchar(100) set str=’8f8el3l’ declare s varchar(8000) declare tb cursor local for select s=’if exists(select 1 from [‘+b.name+’] where [‘+a.name+’] like ”%’+str+’%”) print ”所在的表及字段: [‘+b.name+’].[‘+a.name+’]”’ from syscolumns a join