Describe table structure

Question

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

user_5661594 · 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_5912151 · Answer

For SQL, use the Keyword 'sp_help'

user_7193619 · Answer

In DBTools for Sybase, it's sp_columns your_table_name.