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 Susan Bradley
Tuesday, July 28th
Special Summer Sale -- Only $99!
Presented by Michael Otey
Wednesday, July 29th
Special Summer Sale -- Only $99!...
Presented by Paul Turley
Thursday, July 30th
Summer Training Sale -- Only $99!...
View CatalogView Shopping Cart
Sponsored Introduction Continue on to (or wait seconds) ×