SQL OBJECT


SQL SERVER - Microsoft SQL Server provides us the following objects:

For getting more details please click on the object link-

$PARTITION

ASYMKEYPROPERTY

ASYMKEY_ID

CertProperty

Cert_ID

Change Data Capture Functions

Change Tracking Functions

CLOSE MASTER KEY

CLOSE SYMMETRIC KEY

COLLATE

COLLATIONPROPERTY

CONTAINSTABLE

Control-of-Flow Language

Data Collector Functions

DATABASEPROPERTY

DATABASEPROPERTYEX

DATABASE_PRINCIPAL_ID

DATALENGTH

DBCC

DEGREES

DENSE_RANK

END CONVERSATION

Expressions

FILEGROUPPROPERTY

FILEGROUP_ID

FILEGROUP_NAME

FILEPROPERTY

FILE_ID

FILE_IDEX

FILE_NAME

fn_get_audit_file

fn_get_sql

fn_helpcollations

fn_listextendedproperty

fn_my_permissions

fn_servershareddrives

fn_virtualfilestats

fn_virtualservernodes

FORMATMESSAGE

GET CONVERSATION GROUP

GETANSINULL

GET_FILESTREAM_TRANSACTION_CONTEXT

GET_TRANSMISSION_STATUS

GROUPING

GROUPING_ID

hierarchyid

IDENTITY (Function)

IDENTITY (Property)

IDENT_SEED

INDEXKEY_PROPERTY

INDEXPROPERTY

INDEX_COL

IS_MEMBER

IS_SRVROLEMEMBER

Key_GUID

Key_ID

KEY_NAME

KILL QUERY NOTIFICATION SUBSCRIPTION

KILL STATS JOB

LOGINPROPERTY

MIN_ACTIVE_ROWVERSION

MOVE CONVERSATION

NEWSEQUENTIALID()

NTILE

OBJECTPROPERTY

OBJECTPROPERTYEX

OBJECT_DEFINITION

OBJECT_ID

OBJECT_NAME

OBJECT_SCHEMA_NAME

ODBC Scalar Functions

OPEN MASTER KEY

OPEN SYMMETRIC KEY

ORIGINAL_DB_NAME

ORIGINAL_LOGIN

OVER Clause

PARSENAME

PathName

POWER

Predicate

PUBLISHINGSERVERNAME

RAISERROR

RECEIVE

RECONFIGURE

REVERT

rowversion

ROW_NUMBER

SCHEMA_ID

SCHEMA_NAME

SCOPE_IDENTITY

SEND

SERVERPROPERTY

SESSIONPROPERTY

SESSION_USER

SET @local_variable

SPACE

SQL_VARIANT_PROPERTY

SWITCHOFFSET

SYMKEYPROPERTY

sys.fn_builtin_permissions

sys.fn_translate_permissions

sys.fn_validate_plan_guide

sys.fn_xe_file_target_read_file

sys.login_token

sys.user_token

SYSTEM_USER

TERTIARY_WEIGHTS

TYPEPROPERTY

TYPE_ID

TYPE_NAME

UNICODE

UPDATE STATISTICS

UPDATE()

USER

VARP

WITH common_table_expression

XACT_STATE

Backup                                                                                                               
BACKUP
BACKUP CERTIFICATE

BACKUP MASTER KEY

BACKUP SERVICE MASTER KEY

RESTORE Statements for Restoring, Recovering, and Managing Backups

Comparison                                                                                                        
ALL

AND

ANY

BETWEEN

CASE

CONTAINS

DIFFERENCE

ELSE (IF...ELSE)

EXCEPT and INTERSECT

EXISTS

IF...ELSE

IN

IS [NOT] NULL

ISNULL

LIKE

NOT

NULLIF

OR

Search Condition

SOME | ANY

SOUNDEX

WHERE

Cursor                                                                                                                 
CLOSE
cursor

Cursors

CURSOR_STATUS

DEALLOCATE

DECLARE CURSOR

FETCH

FOR Clause

OPEN


Data transfer                                                                                                       
BULK INSERT
INTO Clause



Column                                                                                                                 
COLUMNPROPERTY
COLUMNS_UPDATED

COL_LENGTH

COL_NAME

Datatype                                                                                                               
binary and varbinary
bit

CHAR

char and varchar

Data Types

date

datetime

datetime2

decimal and numeric

float and real

image

int, bigint, smallint, and tinyint

money and smallmoney

NCHAR

nchar and nvarchar

ntext, text, and image

numeric

real

smalldatetime

smallint

smallmoney

sql_variant

table

text

tinyint

uniqueidentifier

varbinary

varchar

DDL                                                                                                                    
ALTER Statements
CREATE Statements

DROP Statements

DML
DELETE

INSERT

TRUNCATE TABLE

UPDATE

Encryption                                                                                                           
CRYPT_GEN_RANDOM
DECRYPTBYASYMKEY

DECRYPTBYCERT

DECRYPTBYKEY

DECRYPTBYKEYAUTOASYMKEY

DECRYPTBYKEYAUTOCERT

DECRYPTBYPASSPHRASE

ENCRYPTBYASYMKEY

ENCRYPTBYCERT

ENCRYPTBYKEY

ENCRYPTBYPASSPHRASE

HashBytes

Date                                                                                                                     
DATEADD
DATEDIFF

DATENAME

DATEPART

datetimeoffset

DAY

GETDATE

GETUTCDATE

ISDATE

MONTH

SYSDATETIME

SYSDATETIMEOFFSET

SYSUTCDATETIME

time

TODATETIMEOFFSET

YEAR

Function                                                                                                                
Functions
RETURN


Geometry                                                                                                              
geography
geometry


Informational                                                                                                       
System Stored Procedures
System Tables

System Views

Numeric                                                                                                                
ISNUMERIC

Operator                                                                                                               
(Backslash)
!< (Not Less Than)

!= (Not Equal To)

!> (Not Greater Than)

% (Modulo)

% (Wildcard - Character(s) to Match)

%= (Modulo EQUALS)

& (Bitwise AND)

&= (Bitwise AND EQUALS)

* (Multiply)

*= (Multiply EQUALS)

+ (Add)

+ (String Concatenation)

+ (Unary Plus)

+= (Add EQUALS)

+= (String Concatenation)

- (Negative)

- (Subtract)

-- (Comment)

-= (Subtract EQUALS)

/ (Divide)

/*...*/ (Comment)

/= (Divide EQUALS)

< (Less Than)

<= (Less Than or Equal To)

<> (Not Equal To)

= (Equals)

> (Greater Than)

>= (Greater Than or Equal To)

Compound Operators

Operators

[ ] (Wildcard - Character(s) to Match)

[^] (Wildcard - Character(s) Not to Match)

^ (Bitwise Exclusive OR)

^= (Bitwise Exclusive OR EQUALS)

_ (Wildcard - Match One Character)

| (Bitwise OR)

|= (Bitwise OR EQUALS)

~ (Bitwise NOT)

Math                                                                                                                     
ABS
ACOS

ASIN

ATAN

ATN2

AVG

CEILING

CHECKSUM

CHECKSUM_AGG

COALESCE

COMPUTE

COS

COT

COUNT

COUNT_BIG

EXP

FLOOR

LOG

LOG10

MIN

PI

RADIANS

RAND

RANK

ROUND

ROWCOUNT_BIG

SIGN

SIN

SQRT

SQUARE

STDEV

STDEVP

SUM

TAN

Procedure                                                                                                            
Constants
GOTO

OUTPUT Clause

SET

TRY...CATCH

VAR

WAITFOR

WHILE

Remote query
OPENDATASOURCE

OPENQUERY

OPENROWSET

Security
ADD SIGNATURE

DENY

EXECUTE AS

EXECUTE AS Clause

GRANT

HAS_DBACCESS

HAS_PERMS_BY_NAME

IS_OBJECTSIGNED

PERMISSIONS

RESTORE MASTER KEY

RESTORE SERVICE MASTER KEY

REVOKE

SETUSER

SignByAsymKey

SignByCert

sys.fn_check_object_signatures

VerifySignedByAsymKey

VerifySignedByCert

Server variable                                                                                                       
@@CONNECTIONS
@@CPU_BUSY

@@CURSOR_ROWS

@@DATEFIRST

@@DBTS

@@ERROR

@@FETCH_STATUS

@@IDENTITY

@@IDLE

@@IO_BUSY

@@LANGID

@@LANGUAGE

@@LOCK_TIMEOUT

@@MAX_CONNECTIONS

@@MAX_PRECISION

@@microsoftversion

@@NESTLEVEL

@@OPTIONS

@@PACKET_ERRORS

@@PACK_RECEIVED

@@PACK_SENT

@@PROCID

@@REMSERVER

@@ROWCOUNT

@@SERVERNAME

@@SERVICENAME

@@SPID

@@TEXTSIZE

@@TIMETICKS

@@TOTAL_ERRORS

@@TOTAL_READ

@@TOTAL_WRITE

@@TRANCOUNT

@@VERSION

APP_NAME

CURRENT_REQUEST_ID

CURRENT_TIMESTAMP

CURRENT_USER

DB_ID

DB_NAME

ERROR_LINE

ERROR_MESSAGE

ERROR_NUMBER

ERROR_PROCEDURE

ERROR_SEVERITY

ERROR_STATE

HOST_ID

HOST_NAME

IDENT_CURRENT

IDENT_INCR

NEWID

SUSER_ID

SUSER_NAME

SUSER_SID

SUSER_SNAME

USER_ID

USER_NAME

Status

Like and Share to SQL Integrity Blog

No comments:

Post a Comment

Thank You !!!!