From the course: Text to SQL: Amazon Redshift Serverless for Generative SQL in Amazon Q

Unlock this course with a free trial

Join today to access over 25,400 courses taught by industry experts.

Writing a query to create a table in Amazon Redshift Query Editor

Writing a query to create a table in Amazon Redshift Query Editor

From the course: Text to SQL: Amazon Redshift Serverless for Generative SQL in Amazon Q

Start my 1-month free trial Buy for my team

Writing a query to create a table in Amazon Redshift Query Editor

“

- [Instructor] After we've created our database in Amazon Redshift Serverless, we may create a table using the web-based editor, Query Editor v2. If we use the CREATE TABLE statement in SQL, we may provide a table name and then declare the variable names, the data type. And before we execute the command, we close with a semicolon before we run our SQL statement. In this example, we have declared the CREATE TABLE statement followed by a table name for Sydney house prices, and listed the column or variable names with their corresponding data types.

Contents