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, 2884👍, 1💬
Popular Posts:
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...