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, 1306🔥, 0💬
Popular Posts:
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...