get table info by column name
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.COLUMNS
where COLUMN_NAME = 'TaskListItemId';
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.COLUMNS
where COLUMN_NAME = 'TaskListItemId';