Tag Archives: equivalent of oracle desc

01-06-2012 You can use following stored procedures to get table information similar to what you get by calling “Desc” in Oracle. Sp_columns ‘<TableName>’ This will show the list of columns along with other useful information such as: data type, length, Is-Nullable, etc… You can also use sp_help ‘<TableName>’ For even more descriptive information This willContinue reading “How to get Table Information in SQL Server (Equivalent of Oracle’s desc)”