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
Post a Comment