Importing a table from another SQL db

Hi,
I'm new to sql server. In access if we want to link to a table in another db we can "Import" the table and access will consider it as its own table (it can be updated and...). How can we do this in SQL Server, I mean to link to another table from another db on the same server so that we can see the table in the diagrams and views?

ThanksCross-database foreign key references are not supported so this would not be available in the diagrams wizard. You can createa a view that references a table in another db, just use the three part convention, <db>.<owner>.<table name>