Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I find out if the column allows nulls?
Message
 
 
To
25/04/2007 14:24:34
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
01043112
Message ID:
01219886
Views:
8
Sure
IF EXISTS (SELECT * FROM pubs.INFORMATION_SCHEMA.TABLES 
         WHERE table_name = 'authors' AND table_type = 'BASE TABLE')
  -- Table exists
...



>I have a question about the INFORMATION_SCHEMA view.
>
>I query the sysobjects to be sure that the table is in the db, will INFORMATION_SCHEMA allow me to do the same thing?
>
>I can't do a search at this time, other wise I would not be bothering you.
>
>Hope you're having a good day. :-)
>
>Beth
>
>>It's better to use INFORMATION_SCHEMA views than query system tables directly
SELECT * FROM
>>	pubs.INFORMATION_SCHEMA.COLUMNS
>>WHERE table_name = 'authors'	
>>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform