MariaDB/SQL/CREATE: Difference between revisions

Latest revision as of 22:19, 18 February 2025

The CREATE command is how you create various different objects in a database.

@@ Line 5: / Line 5: @@
 * [https://mariadb.com/kb/en/create/ MariaDB Knowledge Base]
 ==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>