Some common knowledge of SQL Server

In SQL Server:

1. The following query statements can be used to query to system tables (system_table), table aliases (synonym), user tables (user_table), Views (view), primary foreign key names, triggers, stored procedures, and so on, based on the different queries of ' Type ':

　　　　SELECT * from SYS. OBJECTS;

2. The table alias (synonym) can be queried by the following query statement:

　　　　SELECT * from SYS. synonyms;

3. The following query statements can be used to query the relevant user table and schema (schema):

　　　　SELECT * from INFORMATION_SCHEMA. TABLES;

4. Create table aliases The DDL format is:

　　　　CREATE synonym table alias for real table name;

5.

Some common knowledge of SQL Server