Posted on February 10, 2012, in SQL Server and tagged list all columns, list all columns except one, list columns, list sql columns, sql columns, sql fieldnames, sql server, sys.columns, sys.objects, table columns. Bookmark the permalink. 2 Comments.
- Join 4 other subscribers
-
Recent Posts
-
- SethThanks Mark - You have a good point - I like this better: SELECT COLUMN_NAME FROM INFORMATION_SCHEMA
- MarkSeth, why do you use the system tables and not the information_schema views? I thought best practice
- alexthanks ! VERY HELPFUL !
- SethThanks Owen. I found this KB article that might help: http://support.microsoft.com/kb/208946
- OwenGreat post. I believe MS Access does not support ROW_NUMBER, but do you know any work-around to achi
- VoicuThank you!
- RonaldFaster would be to use the PIVOT function in T-SQL select * from (select isnull(Color, 'NULL') as Co
- mountain girlWow! This sounds cool, even for the non-technical among us! Congrats on the new blog!
- SQL Server 2008 Prevent Saving Changes Setting (2)
- Grouping with ROW_NUMBER (2)
- Get List of Columns in a Table (2)
- HOW TO GET CONDITIONAL SUM AGGREGATES IN A RECORDSET USING THE CASE STATEMENT (1)
- USING MYSQLDUMP (1)
- STORED PROCS: WHEN TO USE EXECUTE COMMAND? (0)
- A Patriotic SQL Script (0)
- RANDOMIZING RESULTS WITH NEWID (0)
- KILL A LINUX PROCESS BY PROCESS NAME (0)
- LINUX PASS-THROUGH AUTHENTICATION (SSH KEY GENERATION) FOR UBUNTU SIMPLIFIED AND CLARIFIED (0)
- July 2012 (2)
- June 2012 (1)
- May 2012 (2)
- February 2012 (1)
- November 2011 (1)
- October 2011 (1)
- June 2011 (2)
- July 2010 (2)
- May 2010 (1)
- April 2010 (3)
- March 2010 (3)
- February 2010 (2)
- January 2010 (5)
exec find xml columns get all xml columns list all columns list all columns except one list columns list sql columns list xml columns minimum memory per query min memory sql server prevent saving changes prevent saving changes sql Prevent saving changes that require the table re-creation saving changes is not permitted sql columns sql fieldnames sql server stored prodedure execution sys.columns sys.objects table columns UAC user access control Windows 7- Everything Else (2)
- Linux Administration (2)
- MySQL (1)
- SQL Server (20)
- Uncategorized (1)
Blogroll
Top Rated
Seth, why do you use the system tables and not the information_schema views? I thought best practices were to use the information_schema detaisl as much as possible due to potentail changes to the system tables and objects?
Thanks Mark – You have a good point – I like this better:
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = ‘AdventureWorks’
AND TABLE_NAME = ‘Contact’