且构网

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

如何搜索数据库中所选表的所有列

更新时间:2023-02-10 13:29:48

试试这个,

Try this,
select TABLE_NAME from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME='pass_unique_columnname_here'



(或)


(or)

select * from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME='pass_unique_columnname_here'






Hi,

select * from INFORMATION_SCHEMA.COLUMNS where Table_Name=@tableName







谢谢

Dinesh Sharma




Thanks
Dinesh Sharma