I have a SQL Server database and I want to know what columns and types it has. I'd prefer to do this through a query rather than using a GUI like Enterprise Manager. Is there a way to do this?
Use this code:
exec sp_columns table_name
You can also refer to sp_columns stored procedure.