Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
11 Cards in this Set
- Front
- Back
|
Display column level permissions for a table.
|
sp_column_priveleges @table_name
|
|
|
Display column information for a table
|
sp_columns @table_name
|
|
|
List all databases for current instance, including size in KB
|
sp_databases
|
|
|
Display list of all tables with a defined foreign key relationship to the given primary key table
|
sp_fkeys @pktable_name
|
|
|
Display attribute id and values for the current instance
|
sp_server_info
|
|
|
Display columns that uniquely identify a row in a given table
|
sp_speicial_columns @table_name
|
|
|
Display parameter information for a given stored procedure
|
sp_sproc_columns @procedure_name
|
|
|
Display indexes and statistics for a given table
|
sp_statistics @table_name
|
|
|
Display list of stored procedures in current database
|
sp_stored_procedures
|
|
|
Display table level permissions for a table.
|
sp_table_privileges @table_name
|
|
|
Display list of all tables and views in current database
|
sp_tables
|
