Difference between revisions of "MariaDB/SQL/CREATE"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
* [https://mariadb.com/kb/en/create/ MariaDB Knowledge Base] | * [https://mariadb.com/kb/en/create/ MariaDB Knowledge Base] | ||
==Syntax== | ==Syntax== | ||
| − | * CREATE {{l/sub|DATABASE}} | + | * <code>CREATE {{l/sub|DATABASE}}</code> (or <code>SCHEMA</code>) |
| − | * CREATE {{l/sub|TABLE}} | + | * <code>CREATE {{l/sub|TABLE}}</code> |
| − | * CREATE {{l/sub|VIEW}} (create or replace) | + | * <code>CREATE {{l/sub|VIEW}}</code> (create or replace) |
| − | * CREATE {{l/sub|CATALOG}} | + | * <code>CREATE {{l/sub|CATALOG}}</code> |
| − | * CREATE {{l/sub|USER}} | + | * <code>CREATE {{l/sub|USER}}</code> |
| − | * CREATE {{l/sub|TRIGGER}} | + | * <code>CREATE {{l/sub|TRIGGER}}</code> |
| − | * CREATE {{l/sub|EVENT}} | + | * <code>CREATE {{l/sub|EVENT}}</code> |
| − | * CREATE {{l/sub|FUNCTION}} | + | * <code>CREATE {{l/sub|FUNCTION}}</code> |
| − | * CREATE {{l/sub|FUNCTION UDF}} - user-defined function | + | * <code>CREATE {{l/sub|FUNCTION UDF}}</code> - user-defined function |
| − | * CREATE {{l/sub|INDEX}} | + | * <code>CREATE {{l/sub|INDEX}}</code> |
| − | * CREATE {{l/sub|PACKAGE}} | + | * <code>CREATE {{l/sub|PACKAGE}}</code> |
| − | * CREATE {{l/sub|PACKAGE BODY}} | + | * <code>CREATE {{l/sub|PACKAGE BODY}}</code> |
| − | * CREATE {{l/sub|PROCEDURE}} | + | * <code>CREATE {{l/sub|PROCEDURE}}</code> |
| − | * CREATE {{l/sub|ROLE}} | + | * <code>CREATE {{l/sub|ROLE}}</code> |
| − | * CREATE {{l/sub|SEQUENCE}} | + | * <code>CREATE {{l/sub|SEQUENCE}}</code> |
| − | * CREATE {{l/sub|SERVER}} | + | * <code>CREATE {{l/sub|SERVER}}</code> |
Latest revision as of 22:19, 18 February 2025
|
"CREATE" SQL command
|
About
The CREATE command is how you create various different objects in a database.