How to list all tables and each table, loop through each column using SQL query
It is not uncommon to get the list of all column names from all available tables; at times some valuable information peeps out when one researches it. The following query will get you exactly that
select sys.syscolumns.name as ColumnName, sys.sysobjects.name as TableName from sys.syscolumns,sys.sysobjects where sys.sysobjects.id = sys.syscolumns.id
Showing posts with label Column Names frol All Tables using SQL 2008 Query. Show all posts
Showing posts with label Column Names frol All Tables using SQL 2008 Query. Show all posts
Subscribe to:
Posts (Atom)
