Collections:
Creating a New Table in a Given Schema in SQL Server
How To Create a New Table in a Given Schema in SQL Server?
✍: FYIcenter.com
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
2016-10-22, 1379🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...