What is SQL Server Identifier?

What is SQL Server Identifier?

Everything in a SQL server can have an identifier. Be it server, view, trigger, column etc. any database object name is an identifier. Identifiers may or may not be required for all objects.

Example:
CREATE TABLE table_name
(ID INT PRIMARY KEY
Note varchar(20));
Here, ID and Note are two identifiers for the columns. Constraints like Primary key need not have an identifier.
What are classes of identifier?
There are two classes of identifier. These identifiers must contain 1 to 128 characters......
What are the Rules for Regular Identifiers
Rules for Regular Identifiers: These rules are dependant on database compatibility level. For a compatibility level 90, following rules may apply.....
Define Subqueries
A subquery is a query within a query. These sub queries are created with SQL statements. These subqueries are embedded within SELECT, FROM or the WHERE clause........
Post your comment