How to create database object in SQL

Create a database object using SQL: Create table: CREATE TABLE table_name (column_name1 data_type1, ...); Create view: CREATE VIEW view_name AS SELECT column_list FROM table_name WHERE condition; Create index: CREATE INDEX index_name ON table_name (column_name); Create stored procedure: CREATE PROCEDURE procedure_name (

How to create a database object using SQL

When writing SQL queries, it is often necessary to create database objects, such as tables, views, indexes, or stored procedures. Here are the syntax and steps for creating these objects:

Create a table

 <code class="sql">CREATE TABLE table_name ( column_name1 data_type1, column_name2 data_type2, ... );</code>

• table_name is the name of the table to be created.
• column_name is the name of the column of the table.
• data_type is the data type of the column, such as INT , VARCHAR , or DATE .

Create a view

 <code class="sql">CREATE VIEW view_name AS SELECT column_list FROM table_name WHERE condition;</code>

• view_name is the name of the view to be created.
• column_list is a list of columns to include in the view.
• table_name is the table on which the view is to be based.
• condition is an optional WHERE clause that filters the rows to be included in the view.

Create an index

 <code class="sql">CREATE INDEX index_name ON table_name (column_name);</code>

• index_name is the name of the index to be created.
• table_name is the name of the table where the index is located.
• column_name is the column to be indexed.

Create stored procedures

 <code class="sql">CREATE PROCEDURE procedure_name ( @parameter1 data_type1, @parameter2 data_type2, ... ) AS BEGIN -- 存储过程主体END;</code>

• procedure_name is the name of the stored procedure to be created.
• @parameter is a parameter of a stored procedure.
• BEGIN and END tag the body of the stored procedure.

Example

 <code class="sql">CREATE TABLE Customers ( Customer_ID INT PRIMARY KEY, Customer_Name VARCHAR(50) NOT NULL, Customer_Address VARCHAR(100) ); CREATE VIEW ActiveCustomers AS SELECT * FROM Customers WHERE IsActive = 1; CREATE INDEX Customer_Name_Index ON Customers (Customer_Name); CREATE PROCEDURE GetCustomer ( @CustomerID INT ) AS BEGIN SELECT * FROM Customers WHERE Customer_ID = @CustomerID; END;</code>

The above is the detailed content of How to create database object in SQL. For more information, please follow other related articles on the PHP Chinese website!