且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在sql server 2005中找到数据库中所有表的列?

更新时间:2023-02-07 10:15:22

Google [ ^ ]在你的位置?



第一篇文章本身很有前途



http://blog.sqlauthority.com/2008/08/06/sql- server-query-to-find-column-from-all-tables-of-database / [ ^ ]
Did the block Google [^]at your place?

The first article itself is promising

http://blog.sqlauthority.com/2008/08/06/sql-server-query-to-find-column-from-all-tables-of-database/[^]


SELECT *

FROM information_schema.COLUMNS

WHERE column_name LIKE'%Column_name%'
SELECT *
FROM information_schema.COLUMNS
WHERE column_name LIKE '%Column_name%'