column

Hey,
Is it possible to change a column's Allow Nulls property after the table is created?
Thanks,Yes - using alter table. But you have to fill in null values with something if you are going from NULL to NOT NULL.|||FYI - If you have access to bol (Books Online), most of your questions could be answered - including the one you had earlier on primary key constraints.|||What's this books online?|||Oh yeah, and how would I do it using Alter Table??
thanks,|||If you have access to bol (Books Online)... everybody with an internet connection does, it's, um, online

http://msdn.microsoft.com/library/en-us/dnanchor/html/sqlserver2000.asp

for those without a 24/7 internet connection, you can also download BOL in case you want to look stuff up without dialing up...

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

rudy|||Originally posted by vbgladiator
Oh yeah, and how would I do it using Alter Table??
thanks,

http://msdn.microsoft.com/library/en-us/tsqlref/ts_aa-az_3ied.asp|||Rudy - Thanks for posting those links.

vbgladiator - BOL is an online technical reference utility for SQL Server. I would download it - that gives you guaranteed access. You will find that it is an indispensable reference for your SQL Server questions.|||already did :)

Thanks a lot guys.