tsql - Does the 128 character limit for table names include the database name and schema name? -


microsoft's database objects documentation states table names can 128 characters. include schema name? database name?

for example, if needed run following sql statement copies data in source table destination table in different database, i'd write:

select * destinationdatabase.destinationschema.destinationtable sourcedatabase.sourceschema.sourcetable 

now have table stores database name, schema name, , table name both source , destination tables, size limit should put on columns storing these names?

is 128 character limit each part (database name, schema name, table name) or should entire identifier (like destinationdatabase.destinationschema.destinationtable) 128 characters long?

it's length of sysname data type nvarchar(128). it's per element (so table separately 128).


Comments

Popular posts from this blog

account - Script error login visual studio DefaultLogin_PCore.js -

xcode - CocoaPod Storyboard error: -