Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- What I am doing here?
- %dbsqlexec fail
- COLUMNPROPERTY(object_id(c.TABLE_NAME), c.COLUMN_NAME, 'IsIdentity'),
- c.CHARACTER_MAXIMUM_LENGTH,
- c.NUMERIC_PRECISION,
- c.NUMERIC_PRECISION_RADIX,
- c.NUMERIC_SCALE,
- c.DATETIME_PRECISION,
- c.CHARACTER_SET_NAME,
- c.COLLATION_NAME
- from INFORMATION_SCHEMA.COLUMNS c
- join INFORMATION_SCHEMA.TABLES t
- on c.TABLE_SCHEMA = t.TABLE_SCHEMA
- and c.TABLE_NAME = t.TABLE_NAME
- where c.TABLE_CATALOG = 'LW08v6_Empty'
- and t.TABLE_TYPE = 'BASE TABLE'
- and ((c.table_schema = 'dbo' and c.table_name LIKE 'ACCOUNT'))
- order by c.table_schema, c.table_name, c.ordinal_position;
- 2019-01-24T12:34:15.174000Z SQL MSSQL: sending query: -- params: including
- -- filter-list-to-where-clause including
- -- excluding
- -- filter-list-to-where-clause excluding
- select schema_name(schema_id) as SchemaName,
- o.name as TableName,
- REPLACE(i.name, '.', '_') as IndexName,
- co.[name] as ColumnName,
- i.is_unique,
- i.is_primary_key,
- i.filter_definition
- from sys.indexes i
- join sys.objects o on i.object_id = o.object_id
- join sys.index_columns ic on ic.object_id = i.object_id
- and ic.index_id = i.index_id
- join sys.columns co on co.object_id = i.object_id
- and co.column_id = ic.column_id
- where schema_name(schema_id) not in ('dto', 'sys')
- and ((schema_name(schema_id) = 'dbo' and o.name LIKE 'ACCOUNT'))
- order by SchemaName,
- o.[name],
- i.[name],
- ic.is_included_column,
- ic.key_ordinal;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement