The SQL Server Foundation object_id () function

In SQL Server database, if the query database has the index of the specified name or foreign key constraints, etc., often use the object_id (' name ', ' type ') method, take notes as follows:? Syntax: object_id (' objectname ') or object (' objectname ', ' type '): The function returns the ID value of the specified object and can be validated in the sysobjects table. Where the objectname data type is char or nchar. If the data type of object is char, then it is implicitly converted to nchar. Type the following list: AF = Aggregate function (CLR) C = CHECK Constraintd = DEFAULT (constraint or stand-alone) F = FOREIGN KEY Constrain TFN = SQL Scalar Functionfs = Assembly (CLR) Scalar-functionft = Assembly (CLR) table-valued functionif = SQL inline table  -valued Functionit = Internal Tablep = SQL Stored procedurepc = Assembly (CLR) STORED-PROCEDUREPG = Plan GUIDEPK = PRIMARY KEY constraintr = Rule (Old-style, stand-alone) RF = Replication-filter-procedures = System Base TABLESN = SYNONYMSQ = Ser vice Queueta = Assembly (CLR) DML triggertf = SQL TABLE-VALUED-FUNCTIONTR = SQL DML Triggeru = table (user-defined) UQ = UN IQUE Constraintv = viewx = Extended stored procedure? The example is as follows: Select OBJECT_ID (' fk_xxx_xx ', ' F ') takes out the constraint named Fk_xxx_xx ID value, This value is returned as 144444444. The above statement is equivalent: select ID frOm sysobjects where name= ' fk_xxx_xx ' and type= ' F ' ================================================================== ===================== we all know that there is a system table sysobjects in the database that stores information about each object in the database. Can be queried to see the results. You can see that each object has an ID that stores information about tables, stored procedures, triggers, views, and so on.  Note: The field does not have.  OBJECT_ID is the ID of the object that is returned based on the object name.   object_name returns the object name based on the object ID. Select Object_ID (object name) equals: Select id from sysobjects where name= object name select object_name (ID number) equals: select name from Sysobje  CTS where Id=id number

The SQL Server Foundation object_id () function