How to find table structure using T-SQL. Use Database_name SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = ‘Table_name’