get table info by column name

来源:互联网 发布:百度指数数据来源 编辑:程序博客网 时间:2024/05/29 02:21

in sql server .if you only know the column name but forget the table name(ussally in large systems ) , try this :


SELECT COLUMN_NAME,* FROM INFORMATION_SCHEMA.COLUMNSwhere COLUMN_NAME = 'TaskListItemId';


原创粉丝点击