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, 3205🔥, 1💬
Popular Posts:
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...