Monday 11 May 2015

Get SQL Server schema via a SQL query?

 

SELECT * FROM INFORMATION_SCHEMA.TABLES;


SELECT * FROM INFORMATION_SCHEMA.VIEWS;


SELECT * FROM INFORMATION_SCHEMA.COLUMNS ;


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)