Describe table structure

Question

Which query will give the table structure with column definitions in SQL

User · Answer

For Sybase aka SQL Anywhere the following command outputs the structure of a table   DESCRIBE  TABLE NAME

User · Answer

Highlight table name in the console and press ALT F1

User · Answer

For SQL Server use exec sp help USE db name  exec sp help  dbo table name   For MySQL  use describe DESCRIBE table name

User · Answer

select   from INFORMATION SCHEMA COLUMNS where TABLE NAME   lt Table Name gt     You can get details like column datatype and size by this query

User · Answer

For SQL  use the Keyword  sp help

User · Answer

It depends from the database you use  Here is an incomplete list    sqlite3   schema table name Postgres  psql    d table name SQL Server  sp help table name  or sp columns table name for only columns  Oracle DB2  desc table name or describe table name  MySQL  describe table name  or show columns from table name for only columns

User · Answer

sp help tablename in sql server -- sp help      objname      name       desc tablename in oracle -- DESCRIBE   table-Name   view-Name

User · Answer

In DBTools for Sybase  it s sp columns your table name

User · Answer

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

User · Answer

SELECT   FROM INFORMATION SCHEMA COLUMNS WHERE table name    student

User · Answer

This depends on your database vendor  Mostly it s the  information schema  you should Google for  applies to MySQL  MSSQL and perhaps others

User · Answer

DESCRIBE tableName   Check MySQL describe command

User · Answer

In MySQL you can use DESCRIBE  lt table name gt

[sql] Describe table structure

Examples related to sql

Examples related to database