How to check if a column exists in a SQL Server table

by

SQL Server 2005 onwards:

IF EXISTS(SELECT 1 FROM sys.columns 
          WHERE Name = N'columnName'
          AND Object_ID = Object_ID(N'schemaName.tableName'))
BEGIN
    -- Column Exists
END

Martin Smith’s version is shorter:

IF COL_LENGTH('schemaName.tableName', 'columnName') IS NOT NULL
BEGIN
    -- Column Exists
END

More Related Contents:

  1. How do I move a table into a schema in T-SQL
  2. I dont know sql syntax for my table [closed]
  3. Comma separated results in SQL
  4. Understanding PIVOT function in T-SQL
  5. Using T-SQL, return nth delimited element from a string
  6. Get first day of week in SQL Server
  7. Using RegEx in SQL Server
  8. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  9. Confused about UPDLOCK, HOLDLOCK
  10. INSERT INTO vs SELECT INTO
  11. SQL Server 2008 Empty String vs. Space
  12. How do I use the CONCAT function in SQL Server 2008 R2?
  13. How to set a default value for an existing column
  14. Select / Insert version of an Upsert: is there a design pattern for high concurrency?
  15. TSQL: How to convert local time to UTC? (SQL Server 2008)
  16. SQL Server: combining multiple rows into one row
  17. How do I find a stored procedure containing ?
  18. Sequence as default value for a column
  19. How to convert number of minutes to hh:mm format in TSQL?
  20. Convert decimal time to hours and minutes
  21. Avg of float inconsistency
  22. SQL Server Configuration Manager cannot be found
  23. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  24. Joining multiple tables returns NULL value
  25. Instead of trigger in SQL Server loses SCOPE_IDENTITY?
  26. How Can I Detect and Bound Changes Between Row Values in a SQL Table?
  27. How to wait for 2 seconds?
  28. What are row, page and table locks? And when they are acquired?
  29. SQL Server: +(unary) operator on non-numeric Strings
  30. Generate MD5 hash string with T-SQL

Leave a Comment