Da Notes - 70-028 - I

Personal notes on the MCDBA tests. These notes are from the various resources I used to pass the MCDBA exams including the MCDBA sample exams from Transcender.

Passing Score: 680, Questions: 52,  Time: 90 Minutes

Da Notes Index 

[ 70-028 - B ] [ 70-028 - C ] [ 70-028 - D ] [ 70-028 - F ] [ 70-028 - H ] [ 70-028 - I ] [ 70-028 - L ] [ 70-028 - M ] [ 70-028 - N ] [ 70-028 - P ] [ 70-028 - R ] [ 70-028 - S ] [ 70-028 - U ] [ 70-028 - W ]

Information Schema Views

These views provide an internal, system table-independent view of the SQL Server metadata. Information schema views allow applications to work properly even though significant changes have been made to the system tables. 

SELECT * FROM information_schema.table  -  List of tables in the database

SELECT * FROM information_schema.colums -  List of columns in the database

SELECT * FROM information_schema.table_privileges - Security information in database