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, 1511🔥, 0💬
Popular Posts:
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...