Null Column using SQL Query

Question

Hi how can i get a NotNull and Null fields using sql query

Suthish Nair · Answer

Actually your question is not clear. Please explain with more information.. Using this query you can find the table informations.. SELECT * FROM information_schema.columns WHERE table_name = 'Table_1'

krishna prasad · Answer

Hai... while creating the table fields itself we can specify whether the particular filed can accept null values or not... Ex CREATE TABLE [dbo].[mdpatdat]( [RecStat] [char](1) NOT NULL [Entry_User] [char](3) NOT NULL [Entry_Date] [datetime] NOT NULL) Hope it helps.... With Regards P.Krishna Prasad