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
Register now to get the best rates available!
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 John Savill
September 24th @ 11am, 1pm, 3pm EDT
Presented by Tyler Chessman
September 25th @ 11am, 1pm, 3pm EDT
Presented by Paul Thurrott
September 30th @ 11am, 1pm, 3pm EDT
View CatalogView Shopping Cart
Sponsored Introduction Continue on to (or wait seconds) ×