Hi all, By using below query i can get no of tables having the give column name in a particular database, SELECT COUNT(*) AS Counter FROM syscolumns WHERE (name = 'empno') but i want to know the table names too? any one please suggest me how to find table names too...... In other words i know...
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
gjaganmohanrao
on
05-30-2008, 12:00 AM
Filed under: SQL 2000, SQL Server 2005, SQL Server Database connection string, Sql to MS Access, SQLEXPRESS, Troubleshoot SQL connection problems, @@IDENTITY, beginner, Sqldapter, sqldatasource checkboxlist, Binary SQL Server 2005 BLOB, sqldataSource, SQL Server 2005