Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
Using temporary tables [Table of Contents] Managing identity gaps in tables

Transact-SQL User's Guide

[-] Chapter 7 Creating Databases and Tables
[-] Creating tables
[-] Creating tables in different databases

Creating tables in different databases

As the create table syntax shows, you can create a table in a database other than the current one by qualifying the table name with the name of the other database. However, you must be an authorized user of the database in which you are creating the table, and you must have create table permission in it.

If you are using pubs2 or pubs3 and there is another database called newpubs, you can create a table called newtab in newpubs like this: 

create table newpubs..newtab (col1 int)

You cannot create other database objects--views, rules, defaults, stored procedures, and triggers--in a database other than the current one.

Using temporary tables [Table of Contents] Managing identity gaps in tables