OBJECT_ID ('student',在SQL里IF OBJECT_ID ('student','U') IS NOT NULL U

来源：学生作业帮助网编辑：作业帮时间：2024/11/16 12:58:45

OBJECT_ID ('student',在SQL里IF OBJECT_ID ('student','U') IS NOT NULL U
OBJECT_ID ('student',在SQL里
IF OBJECT_ID ('student','U') IS NOT NULL U

OBJECT_ID ('student',在SQL里IF OBJECT_ID ('student','U') IS NOT NULL U
OBJECT_ID ( '[ database_name . [ schema_name ] . | schema_name . ]
object_name' [ ,'object_type' ] )
Object type:
AF = Aggregate function (CLR)
C = CHECK constraint
D = DEFAULT (constraint or stand-alone)
F = FOREIGN KEY constraint
FN = SQL scalar function
FS = Assembly (CLR) scalar-function
FT = Assembly (CLR) table-valued function
IF = SQL inline table-valued function
IT = Internal table
P = SQL Stored Procedure
PC = Assembly (CLR) stored-procedure
PG = Plan guide
PK = PRIMARY KEY constraint
R = Rule (old-style, stand-alone)
RF = Replication-filter-procedure
S = System base table
SN = Synonym
SQ = Service queue
TA = Assembly (CLR) DML trigger
TF = SQL table-valued-function
TR = SQL DML trigger
U = Table (user-defined)
UQ = UNIQUE constraint
V = View
X = Extended stored procedure

OBJECT_ID ('student',在SQL里IF OBJECT_ID ('student','U') IS NOT NULL U IF OBJECT_ID(N'STUDENT') IS NOT NULL DROP TABLE STUDENT GO 这是T-SQL语句,IF OBJECT_ID(N'STUDENT') IS NOT NULLDROP TABLE STUDENTGO这是T-SQL语句, student select * from v$locked_object a,user_objects b where a.OBJECT_ID = b.object_id(+) 后面的（+）啥意思 SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[#TEMPID1]') AND type in (N'U')sys.objects ,OBJECT_ID(N'[dbo].[#TEMPID1]'); type in (N'U');各部分什么意思? 数据库中if OBJECT_ID ('dbo.table_test_6_1','u') is not null drop table table_test_6_1判断是否存在该 student英文翻译 student中文翻译 student number student造句 student number student是什么意思 student是什么? student是什么 new student Student Staff student是什么意思 new student