A. There are two ways (with SQL 7) :- IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '<tbl>' AND COLUMN_NAME = '<col>') or if columnproperty (object_id('<tbl>'), '<col>', 'AllowsNull') IS NOT NULL
The Windows IT Pro forums are moving to myITforum.com! Get answers to questions, share tips, and engage with the IT professional community.
Presented by Mel Beckman
Thursday, April 30th
Enroll Now and Save $75!
View CatalogView Shopping Cart
Sponsored Introduction Continue on to (or wait seconds) ×