You simply have to supply the schema name when referencing the object:

myschema.TheTable
yourschema.TheTable

if I use schemaname.tablename,  system wll show "Incorrect syntax near '.'." as the picture

Instead of...

thank you Johan Bijnens!

but some databases are still SQL server 2008.

Thanks,  I know we can get some informations about foreign key Thru below statement.

SELECT OBJECT_NAME(FK.referenced_object_id) AS 'Referenced Table',

OBJECT_NAME(FK.parent_object_id) AS 'Referring Table',

FK.name AS 'Foreign Key',

COL_NAME(FK.referenced_object_id, FKC.referenced_column_id) AS 'Referenced Column',

COL_NAME(FK.parent_object_id, FKC.parent_column_id) AS...

You have a hypothetical index in the list on the right.  It isn't a real index  Google search the following: MS SQL Server hypothetical indexes

ok,I'll google what the MS...

sorry, my sql server is 2008 R2

1. Not generally available. If an index was created by adding a PRIMARY KEY constraint, sys.objects would have the create time of that index.

2. Yes. For example: SELECT t.name...

This may get you some of what you want.

SELECT 
SS.name SchemaName, 
ST.name TableName, 
ISNULL(SI.name, '') IndexName, 
SI.type_desc IndexType, 
IUS.user_updates, 
IUS.user_seeks, 
IUS.user_scans, 
IUS.user_lookups, 
SSI.rowcnt, 
SSI.rowmodctr, 
IUS.last_user_seek, 
IUS.last_user_scan,...

Ant-Green , Thank you for your kind help!

well noted, thank you Ant-Green!

The things you mention don't typically cause the crazy increase you speak of.  And I just told you a "good way" to find it so someone can...

The things you mention don't typically cause the crazy increase you speak of.  And I just told you a "good way" to find it so someone can fix it....

Crazy increases in size are normally due to a query that has one or more "accidental Cross Joins" in the form of "Many-to-Many" results.  They typically contain a DISTINCT...

For best overall performance, it's extremely likely that you need to change the clustering index on the table to be ( OrderID, ItemID ).  Especially if the table is...

I think I can help with that one.

IDX1 would have the 3 columns with the data ordered by OrderID, then ItemID, and finally Status.  If there were more columns...

thank you !

if I create the following on the table , could you please tell the...