How do you LOOK AT schema? SQL Equiv of DESCRIBE TABLE?

[Timm Taylor]

Hello all,
Oracle has a DESCRIBE TABLE function that SHOWS the current schema. What is
the SQL comparable function? I know about ALTER TABLE.... I just want to SEE
it.

[Dan Guzman]

Try:

EXEC sp_help 'MyTable'

Also, you can use the ANSI standard INFORMATION_SCHEMA views for adhoc
metadata queries:

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'dbo' AND
TABLE_NAME = 'MyTable'
ORDER BY ORDINAL_POSITION

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"Timm Taylor" <timm...@bellsouth.net> wrote in message
news:Seo8a.153795$ED.3...@fe06.atl2.webusenet.com...