I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries - can you change a name of a query and have the subsequent queries that use that query, reflect the change.
Results 1 to 15 of 24
Thread: Change table name
-
5 Star Lounger
- Join Date
- Jan 2001
- Posts
- 1,110
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2010-01-14 05:31
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
5 Star Lounger
- Join Date
- Jan 2001
- Posts
- 1,110
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2010-01-14 05:31I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries - can you change a name of a query and have the subsequent queries that use that query, reflect the change.
-
5 Star Lounger
- Join Date
- Jan 2001
- Posts
- 1,110
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2010-01-14 05:31I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries - can you change a name of a query and have the subsequent queries that use that query, reflect the change.
-
5 Star Lounger
- Join Date
- Jan 2001
- Posts
- 1,110
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2010-01-14 05:31I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries - can you change a name of a query and have the subsequent queries that use that query, reflect the change.
-
5 Star Lounger
- Join Date
- Jan 2001
- Posts
- 1,110
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2010-01-14 05:31I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries - can you change a name of a query and have the subsequent queries that use that query, reflect the change.
-
5 Star Lounger
- Join Date
- Jan 2001
- Posts
- 1,110
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2010-01-14 05:31I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries - can you change a name of a query and have the subsequent queries that use that query, reflect the change.
-
5 Star Lounger
- Join Date
- Jan 2001
- Posts
- 1,110
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2010-01-14 05:31I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries - can you change a name of a query and have the subsequent queries that use that query, reflect the change.
-
5 Star Lounger
- Join Date
- Jan 2001
- Posts
- 1,110
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2010-01-14 05:31I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries - can you change a name of a query and have the subsequent queries that use that query, reflect the change.
-
Platinum Lounger
- Join Date
- Nov 2001
- Location
- Vienna, Wien, Austria
- Posts
- 5,009
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2010-01-14 10:23The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind - as well as copying & renaming the Tables.
If you open up the relevant Query in DesignView, you should be able to see - depending on the circumstances - the relevant Table or Query that would need renaming.
HTHGrüße
-
Platinum Lounger
- Join Date
- Nov 2001
- Location
- Vienna, Wien, Austria
- Posts
- 5,009
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2010-01-14 10:23The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind - as well as copying & renaming the Tables.
If you open up the relevant Query in DesignView, you should be able to see - depending on the circumstances - the relevant Table or Query that would need renaming.
HTHGrüße
-
Platinum Lounger
- Join Date
- Nov 2001
- Location
- Vienna, Wien, Austria
- Posts
- 5,009
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2010-01-14 10:23The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind - as well as copying & renaming the Tables.
If you open up the relevant Query in DesignView, you should be able to see - depending on the circumstances - the relevant Table or Query that would need renaming.
HTHGrüße
-
Platinum Lounger
- Join Date
- Nov 2001
- Location
- Vienna, Wien, Austria
- Posts
- 5,009
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2010-01-14 10:23The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind - as well as copying & renaming the Tables.
If you open up the relevant Query in DesignView, you should be able to see - depending on the circumstances - the relevant Table or Query that would need renaming.
HTHGrüße
-
Platinum Lounger
- Join Date
- Nov 2001
- Location
- Vienna, Wien, Austria
- Posts
- 5,009
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2010-01-14 10:23The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind - as well as copying & renaming the Tables.
If you open up the relevant Query in DesignView, you should be able to see - depending on the circumstances - the relevant Table or Query that would need renaming.
HTHGrüße
-
Platinum Lounger
- Join Date
- Nov 2001
- Location
- Vienna, Wien, Austria
- Posts
- 5,009
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2010-01-14 10:23The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind - as well as copying & renaming the Tables.
If you open up the relevant Query in DesignView, you should be able to see - depending on the circumstances - the relevant Table or Query that would need renaming.
HTHGrüße
-
Platinum Lounger
- Join Date
- Nov 2001
- Location
- Vienna, Wien, Austria
- Posts
- 5,009
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2010-01-14 10:23The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind - as well as copying & renaming the Tables.
If you open up the relevant Query in DesignView, you should be able to see - depending on the circumstances - the relevant Table or Query that would need renaming.
HTHGrüße
