Determines whether a field in the database exists.

-- Determine whether ifexists (select1frommaster .. sysdatabaseswherenameTestDB) printTestDB elseprintTestDB does not exist -- determine whether the table has ifexists (select * fromTestDB .. syscolumnswhereidobject_id (TestDB. dbo. testTb) in the print table TestTb, else exists.

-- Determine whether if exists (select 1 from master .. sysdatabases where name = TestDB) print TestDB else print TestDB does not exist -- determine whether the table exists if exists (select * from TestDB .. syscolumns where id = object_id (TestDB. dbo. testTb) in the print table TestTb, else exists.

-- Determine whether if exists (select 1 from master .. sysdatabases where name = 'testdb') print 'testdb has 'else print 'testdb doesn't exist' -- determine whether the table exists if exists (select * from TestDB .. syscolumns where id = object_id ('testdb. dbo. testTb ') print' table TestTb has 'else print' table TestTb does not exist '-- determine whether the [Name] field if exists (select * from TestDB .. syscolumns where id = object_id ('testdb. dbo. testtb') and name = 'name') print 'field Name exists in 'else' field Name does not exist'