SQL语句快速入门（国外英文资料）.doc

SQL语句快速入门（国外英文资料） Create a database Create database bvtc_db - database name On primary - specifies the file in the main file group. The default is the first file ( Name = bvtc_db_data -- specifies the name of the master data file (logical name) Filename = F: \ bvtc_db_data. MDF, - specifies the main operating system file name and path. Must be installed for SQL server folders on your computer. (the physical file name) Size = 5MB, the initial capacity size Maxsize = 20MB - maximum capacity Filegrowth = 20% - file growth (10% at default, no more than maxsize) ) Log on -- specifies the transaction log file that establishes the database, and the file extension is called: LDF (name = bvtc_db_log -- specifies the transaction log file logical name Filename = F: \ bvtc_db_log.ldf - specify the physical file name Size = 10MB, the initial capacity size Filegrowth = 2MB - file growth ) Collate Chinese_PRC_CI_AS - specifies the default sort method The GO View the database information In addition to looking directly at the database properties, we use the system stored procedure sp_helpdb: Exec sp_helpdb bvtc_db - exec is the execution statement, bvtc_db is the database name Managing the database (1) open or switch database: use bvtc_db (2) change the database capacity: you can change it directly in the database attribute, or you can use the following statement: Use bvtc_db The go The alter database bvtc_db Modify the file ( Name = bvtc_db_data, - also can be a transaction log file (bvtc_db_log) Size = 20 MB ) (3) reducing database capacity: Method 1: right-click the database name - all tasks - shrink the database Method 2: DBCC shrinkdatabase (database_name [, masteroverride]) Example: Use bvtc_db The go Exec sp_dboption bvtc_db, single user, TRUE is set to a single user mode before reducing the database. The go DBCC shrinkdatabase ( bvtc_db ) - this is where the database is reduced to minimal capacity. The go Exec sp_dboption bvtc_db, single user, FALSE The go (4). Method 1: da