Answer Posted / mohammadali.info
Syntax #1 - Copying all columns from another table
The basic syntax is:
CREATE TABLE new_table
AS (SELECT * FROM old_table);
For example:
CREATE TABLE suppliers
AS (SELECT *
FROM companies
WHERE id > 1000);
Syntax #2 - Copying selected columns from another table
The basic syntax is:
CREATE TABLE new_table
AS (SELECT column_1, column2, ... column_n FROM old_table);
For example:
CREATE TABLE suppliers
AS (SELECT id, address, city, state, zip
FROM companies
WHERE id > 1000);
Syntax #3 - Copying selected columns from multiple tables
The basic syntax is:
CREATE TABLE new_table
AS (SELECT column_1, column2, ... column_n
FROM old_table_1, old_table_2, ... old_table_n);
For example:
CREATE TABLE suppliers
AS (SELECT companies.id, companies.address, categories.cat_type
FROM companies, categories
WHERE companies.id = categories.id
AND companies.id > 1000);
Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
What is an execution plan? When would you use it?
What are the different authentication modes in sql server?
What is the order by used for?
What are triggers in ms sql server?
What is importing utility?
What is database mirroring?
What is function of ROLLUP ?
What is the significance of null value and why should we avoid permitting null values?
How many columns can we include on clustered index ?
Does a full backup include transaction log?
How to delete multiple rows with one delete statement in ms sql server?
How to check status of stored procedure in sql server?
what's the maximum size of a row? : Sql server database administration
How to list all objects in a given schema?
What is change tracking in sql server?