Collections:
"sys.tables" - Getting a List of All Tables in SQL Server
How To Get a List of All Tables with "sys.tables" View in SQL Server?
✍: FYIcenter.com
If you want to see the table you have just created, you can use the "sys.tables" system view to get a list of all tables in the current database. The tutorial script gives you a good example:
SELECT name, type_desc, create_date FROM sys.tables GO name type_desc create_date tip USER_TABLE 2007-05-19 23:05:43.700
The output shows that there is only one table in the current database.
⇒ "sys.columns" - Getting a List of Columns in a Table in SQL Server
⇐ CREATE TABLE - Creating New Tables in SQL Server
2018-03-29, 3314🔥, 1💬
Popular Posts:
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...