SELECT name FROM sysobjects WHERE id IN
(SELECT id FROM syscolumns WHERE name = '' )
another simple query to return all the column names.
select table_name,column_name from information_schema.colum
Tuesday, May 18, 2010
SQL-Query-to-find-out-a-particular-field-name-across-all-tables-in-a-Database
Views
0 comments:
Post a Comment