Microsoft SQL Server query tips

 

Get column details of a table

select name from sys.columns where object_name(object_id)='table_name'

 

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *