Quering Table Attributes

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

SSC Guru

Points: 51650

August 26, 2003 at 9:09 am

sp_columns 'yourtablename'

NPeeters SSChampion Points: 12535 More actions · Answer 2



sp_help <table name>

Returns more information like indexes, foreign keys, ... in a nice format in QA.

Greg Larsen SSC-Insane Points: 20961 More actions · Answer 3

You might also try:

select * from information_schema.columns where table_name = '<yourtable>'

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Gregory A. Larsen, MVP

mightyjoemad Mr or Mrs. 500 Points: 586 More actions · Answer 4

Mr or Mrs. 500

Points: 586

August 26, 2003 at 2:14 pm

Thanks

sp_columns did the trick

cneuhold Hall of Fame Points: 3375 More actions · Answer 5

hi!

you might want to have a look at

to get comprehensive information ...

best regards,

chris.