I understand that sp_help and sp_columns can give a description of a table
for me.
However, sp_help sees only the tables in the current schema, and
sp_columns 'COLUMNS', 'INFORMATION_SCHEMA'
returns an empty result, too.
How can I query the descriptions of tables in other than the current schema?USE master
EXEC sp_help 'INFORMATION_SCHEMA.COLUMNS'
EXEC sp_columns 'COLUMNS'
--
David Portas
SQL Server MVP
--
Friday, March 9, 2012
Get the description of INFORMATION_SCHEMA.COLUMNS
Labels:
current,
database,
description,
information_schemacolumns,
microsoft,
mysql,
oracle,
schema,
sees,
server,
sp_columns,
sp_help,
sql,
table,
tables
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment