General MySQL Oracle SQL Server

Creating a New Table in a Given Schema in SQL Server

Q

How To Create a New Table in a Given Schema in SQL Server?

✍: FYIcenter.com

A

When you create a new table, you can specify in which schema you want this table to be located by prefixing the table name with the schema name. In the tutorial example below, a new table "test" is created in schema "fyi": 

USE FyiCenterData;
GO

CREATE TABLE fyi.test (id INT);
GO
Command(s) completed successfully.

SELECT t.name AS table_name, t.type_desc, 
   s.name AS schema_name
   FROM sys.tables t, sys.schemas s
   WHERE t.schema_id = s.schema_id
   AND t.name = 'test';
GO
table_name  type_desc   schema_name
----------- ----------- ------------
test        USER_TABLE  fyi

The last query confirms that table "test" is inside schema "fyi".

 

⇒ Transferring Tables from One Schema to Another in SQL Server

⇐ sys.schemas - Listing All Schemas in a Database in SQL Server

⇑ Creating and Managing Schemas in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-10-22, 1291🔥, 0💬

General MySQL Oracle SQL Server