describe table structure

Question

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

Answer 1

sp_help tablename in sql server

desc tablename in oracle

Answer 2

This depends on your database vendor. Mostly it's the "information schema" you should Google for (applies to MySQL, MSSQL and perhaps others).

Answer 3

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

You can get details like column datatype and size by this query

Answer 4

In MySQL you can use DESCRIBE <table_name>

Answer 5

DESCRIBE tableName

Check MySQL describe command

Answer 6

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