SQL Administration

Database administration — CREATE DATABASE, GRANT, REVOKE, SHOW, DESCRIBE. This category documents 41 SQL administration entries, and each page gives you the full syntax, the parameter list, the return value, and a runnable example tested against MySQL, PostgreSQL, SQL Server, and SQLite. The entries are: CREATE USER, GRANT, REVOKE, SHOW TABLES, DESCRIBE / DESC, SHOW INDEX, SHOW CREATE TABLE, SHOW DATABASES, SHOW PROCESSLIST, KILL, ALTER USER, DROP USER, RENAME USER, FLUSH PRIVILEGES, SET PASSWORD, INFORMATION_SCHEMA, SHOW ENGINES, BACKUP DATABASE, DBCC CHECKDB, sp_who / sp_who2, RESTORE DATABASE, @@ROWCOUNT, Execution Plan Cache, Missing Index Detection, Query Store (Performance), COLUMN LEVEL ENCRYPTION, SHOW CREATE DATABASE, DBCC SHRINKDATABASE, CHECKPOINT / FLUSH, RENAME DATABASE, PASSWORD HASHING (bcrypt), SYSTEM_USER / SESSION_USER / CURRENT_USER, SQL NAMING CONVENTIONS, Row-Level Security (RLS), TRANSPARENT DATA ENCRYPTION (TDE), AUDIT (SQL Server / Oracle), SQL Server DBCC USEROPTIONS, SQL Server sp_spaceused, ClickHouse / BigQuery SQL Syntax, Snowflake SQL Extensions, and more. Not sure where to start? CREATE USER and GRANT are the most commonly used entries in this category. You can also search across every category from the search page, browse the complete A–Z index, or try any of these statements live in the SQL playground.