Describe the structure of the table

Question

What query will give the table structure with column definitions in SQL?

Answer 1

The name of the sp_help table on the sql server is sp_help [ [ @objname = ] 'name' ]

DESCRIBE { table-Name | view-Name } DESCRIBE { table-Name | view-Name } desc in oracle - DESCRIBE { table-Name | view-Name } DESCRIBE { table-Name | view-Name } DESCRIBE { table-Name | view-Name } DESCRIBE { table-Name | view-Name }

Answer 2

It depends on the database you are using. Here is a partial list:

• .schema table_name : .schema table_name
• Postgres (psql): \d table_name
• SQL Server: sp_help table_name (or sp_columns table_name for columns only)
• Oracle DB2: name- desc table_name or describe table_name
• MySQL: describe table_name (or show columns from table_name for columns only)

Answer 3

In MySQL you can use DESCRIBE <table_name>

Answer 4

 select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='<Table Name>' 

You can get data like column data type and size for this query

Answer 5

 SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'student' 

Answer 6

 DESCRIBE tableName 

Check MySQL describe command

Answer 7

Highlight the table name in the console and press ALT + F1

Answer 8

For Sybase aka SQL Anywhere, the following command displays the table structure:

 DESCRIBE 'TABLE_NAME'; 

Answer 9

It depends on the provider of your database. Basically this is an "information scheme" in which you should use Google (applicable to MySQL, MSSQL, and possibly others).

Answer 10

Sql Server

 DECLARE @tableName nvarchar(100) SET @tableName = N'members' -- change with table name SELECT [column].*, COLUMNPROPERTY(object_id([column].[TABLE_NAME]), [column].[COLUMN_NAME], 'IsIdentity') AS [identity] FROM INFORMATION_SCHEMA.COLUMNS [column] WHERE [column].[Table_Name] = @tableName 

Answer 11

For SQL, use the sp_help keyword

Answer 12

In DBTools for Sybase, this is sp_columns your_table_name .