How can I retrieve the table structure from a sql database?

Question

So basically I want a SQL Command that return every column in the table and the datatype that is in that column and whether is nullable.

*Which* implementation of SQL? Also, did you search at all before asking? I feel like this must have been asked already. — underscore_d, Nov 13 '19 at 16:49

score 1 · Accepted Answer · answered Nov 13 '19 at 16:50

1

You can use information schema.

SELECT 
  COLUMN_NAME,
  DATA_TYPE, 
  IS_NULLABLE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'yourTableName'

answered Nov 13 '19 at 16:50

SQLChao

I had to add an " USE 'DatabaseName'" but now it works. – Monocito Nov 15 '19 at 11:14

1 Answers1