September 24, 2004 at 9:22 am
I know that in Oracle/SQL*Plus, if I type 'desc tablename', it will give
me information on the table. This command doesn't seem to work in SQL
Server. Anyone know if there's an equivalent?
September 24, 2004 at 10:47 am
Yup; I believe this is ANSI92 compliant.
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'sometable'
-- Mitch
September 24, 2004 at 11:26 am
Thanks. I appreciate the response.
September 24, 2004 at 2:46 pm
sp_help tablename gives information on tables.
September 24, 2004 at 3:03 pm
very helpful, thank you very much.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply