SQL Server

Sometimes we need to know the table structure information of a database. We need to know the information like columns name, data type, length etc. There are multiple options to find the information. Some of them are

sp_columns: You can execute sp_columns and get the columns information of the table.
Example: exec sp_columns ‘Table Name’

sp_help: You can execute sp_help and get the all the necessary information of the table.
Example: exec sp_help ‘Table Name’

Subscribe to RSS - SQL Server