Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Allow Null

Status
Not open for further replies.
castore

castore

Programmer
Apr 1, 2005
18
IT
Is there any possibility (D7) to know if a field has been declared 'Allow Null' in table structure of MSSQL DB?

Thanks


 
Sort by date Sort by votes
You can run this query:

SELECT * FROM INFORMATION_SCHEMA.columns

there are a lot of info

Giovanni Caramia

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

CritterLover
  • Locked
  • Question
Recordset.MovePrevious - "Operation not allowed in this Context" error 1
Replies
6
Views
274
CritterLover
CritterLover
tjcusick
  • Locked
  • Question
Checking for Null values
Replies
2
Views
1K
roo0047
roo0047
aitpeter
  • Locked
  • Question
Circular Datalinks are not allowed
Replies
3
Views
533
aitpeter
aitpeter
Opieo
  • Locked
  • Question
Access Allow Zero Length from Delphi 1
Replies
13
Views
266
Opieo
Opieo
schultz2146
  • Locked
  • Question
newbie Q. on Table providing a null value to end loop 1
Replies
4
Views
84
MagicFrisbee
MagicFrisbee

Part and Inventory Search

Sponsor

Back
Top