Display Table Details 2

[clayton74]

Hello
I was wondering if therre is a SQL command to view the details of a table, column name, data type, length, allow nulls. I use to have code but I have mislaid it. Any help would be grateful

 

[gmmastros]

Select * From Information_Schema.Columns Where Table_Name = '[!]YourTableNameHere[/!]'

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

One way

select table_name,column_name,data_type,coalesce(column_default,'') as column_default,is_nullable,
CHARACTER_MAXIMUM_LENGTH,
NUMERIC_PRECISION, 
NUMERIC_PRECISION_RADIX ,
NUMERIC_SCALE
 from INFORMATION_SCHEMA.COLUMNS 
where table_name = 'YourTableName'
[code]

Denis The SQL Menace 
SQL blog:[URL unfurl="true"]http://sqlservercode.blogspot.com/[/URL] 

Personal Blog:[URL unfurl="true"]http://otherthingsnow.blogspot.com/[/URL]

 

[clayton74]

Many thanks