Sql server notes

From raju

sort after

Q. How to get column names in sql server?

A. You can use sp_help in SQL Server 2008.

    sp_help <table_name>;
    

Keyboard short-cut for the above command: select table name (highlight it) and press ALT+F1

Ref:- https://stackoverflow.com/a/9750673/6305733