How do I describe a table in SQL Server Management Studio 2008?

You can use sp_columns, a system stored procedure for describing a table. You can also use sp_help. Show activity on this post.

Table of Contents

How can we describe table?

Describes either the columns in a table or the current values, as well as the default values, for the stage properties for a table. DESCRIBE can be abbreviated to DESC.

How do you find the DDL of a table?

Statement 1. CREATE TABLE My_Table (COLUMN1 VARCHAR2(1), COLUMN2 NUMBER(1)) Table created.
Statement 2. BEGIN DBMS_METADATA. SET_TRANSFORM_PARAM(DBMS_METADATA.
Statement 3. select DBMS_METADATA.GET_DDL(object_type, object_name) from user_objects where object_type = ‘TABLE’ and object_name = ‘MY_TABLE’

What is DDL command in SQL?

The DDL commands in SQL are used to create database schema and to define the type and structure of the data that will be stored in a database. SQL DDL commands are further divided into the following major categories: CREATE. ALTER. DROP.

How do I get a list of columns in SQL?

In a query editor, if you highlight the text of table name (ex dbo. MyTable) and hit ALT + F1 , you’ll get a list of column names, type, length, etc.

How do I get a list of all columns in a table in SQL Server?

Getting The List Of Column Names Of A Table In SQL Server

Information Schema View Method. You can use the information schema view INFORMATION_SCHEMA.
System Stored Procedure SP_COLUMNS Method. Another method is to use the system stored procedure SP_COLUMNS.
SYS.COLUMNS Method.
SP_HELP Method.

How do I print a SQL table schema?

In Management Studio,

Click the “+” next to your database expanding the objects below it and click on “Tables”
Open the Tables detail view by selecting “View” -> “Object Explorer Details” from the menu.
Now select all tables (on the right hand side in the object details)

How get DDL from table in SQL?

To generate the table DDL via query, you can use show create command. SHOW CREATE TABLE yourTableName; The above syntax is MySQL specific. Suppose, we have a table with the name ‘DDLOfTableStudent’.