List of statements and stored procedures of the MS SQL Server database language
ALTER TABLE | Change the structure of an existing database table. It is possible to add, delete or change the column. |
---|
BACKUP DATABASE | Database backup |
---|
CREATE TABLE | Creates new database table |
---|
DELETE | Delete rows in the table |
---|
DROP TABLE | Delete database table |
---|
INSERT | Adds new record into the database table |
---|
RESTORE DATABASE | Restore the database from the backup |
---|
SELECT | Data query. The result is always in the table form. |
---|
sp_addlogin | Creates a login account for the connection to the SQL Server instance with using the SQL Server authentication |
---|
sp_addrolemember | Adds an account as a database role member of the SQL Server in the current database |
---|
sp_addsrvrolemember | Adds an account as a fixed role member of the SQL Server |
---|
sp_grantdbaccess | Enable an access of the specified login account to the current database |
---|
sp_password | Change the password of the login account |
---|
sp_rename | Change the name of a user created object (table, column, etc.) in the current database |
---|
sp_tables | Returns a list of objects that can appear in the clause FROM (table, view) |
---|
UPDATE | Change values in the existing table record |
---|
USE | Change the database context (current, default database) |
---|