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