Wednesday, June 12, 2013

Oracle describe like functionality in MSSQL

If you are looking for Oracle's describe functionality in MSSQL, you can use following stored porc.

EXECUTE sp_help 'MyTable';
EXECUTE sp_columns 'MyTable'
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)