Friday, October 18, 2019

SQL Practice 1 - ResultSets , Object ID


SELECT OBJECT_ID('[ErrorLog]')
SELECT OBJECT_name(277576027)
SELECT OBJECT_NAME(object_id), SCHEMA_NAME(schema_id), * FROM sys.tables


sys_objects
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-objects-transact-sql?view=sql-server-ver15


all types in SQL

No comments:

Post a Comment